Finding duplicate's in one table

[Guest_imported]

Hello,

I need help with a query that I'm trying to build. I'm trying to select software audit data from a table. I need to filter out duplicate data based on two fields. I am unsure how to go about this so any help is appreciated.

Thanks

 

[THoey]

You can create a query using the wizard, but that will show you all the duplicates (original record and duplicate). Easiest way is to make a duplicate of the table structure, set some sort of uniqueness constraint so that duplicates won't be allowed, and then write a query to copy all records from the old table to the new. It will kick out any dupes based on your constraint. Then you could rename the old table to keep as a backup (if you want) and then rename the new table to the old table name. Terry M. Hoey

 

[RookieDBO]

Another approach is to use the "Total" and choose "Last" or "Max" in the corresponding field or all of them. Try that.


RookieDBO

 

[Guest_imported]

I frequently have to deal with merging the contents of two files (whoops, I meant "tables&quot and once the stuff is in Access, the null value/indicator is more than I can bear. Simple comparisons of, for example, house number, street, apaartment number, and city/state/zip become horrendous. That is, they did until I decided this stuff can all be put into a synthetic value which ignores null fields and lets me make an absolute comparison against the values in the other table. Works like a charm. There's got to be a more elegant solution, but I just couldn't figure it out.

Any other ideas?

Regards,

John

accuratus@earthlink.net