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?
|