If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Excluding duplicate records in query
I have a table with about 300,000 records. Many are duplicates. I'm trying to
create a make-table query to get only 1 copy of each record while ignoring the duplicate records. Does anyone know how I can do this? For example I have one column in the table that has phone numbers, is there a wayt o only get the first record that has the phone number while ignoring all the other records that have the same phone number? |
#2
|
|||
|
|||
Excluding duplicate records in query
A fast way if all fields are duplicated is to do a totals query and Group By
all columns. "Roman B." wrote: I have a table with about 300,000 records. Many are duplicates. I'm trying to create a make-table query to get only 1 copy of each record while ignoring the duplicate records. Does anyone know how I can do this? For example I have one column in the table that has phone numbers, is there a wayt o only get the first record that has the phone number while ignoring all the other records that have the same phone number? |
#3
|
|||
|
|||
Excluding duplicate records in query
I think that would only eliminate duplicates where all the fields were
equal. Perhaps, Group By the phone number and use FIRST on all the other fields. That won't necessarily get the first record that has the phone number, but it will get on of the records. Another method is to build the table structure and set a unique index on the phone number. Then do an insert into the built table. You will get an error saying that ## records could not be added due to conflict in the index. However, the query will insert one record with each phone number. "KARL DEWEY" wrote in message ... A fast way if all fields are duplicated is to do a totals query and Group By all columns. "Roman B." wrote: I have a table with about 300,000 records. Many are duplicates. I'm trying to create a make-table query to get only 1 copy of each record while ignoring the duplicate records. Does anyone know how I can do this? For example I have one column in the table that has phone numbers, is there a wayt o only get the first record that has the phone number while ignoring all the other records that have the same phone number? |
Thread Tools | |
Display Modes | |
|
|