duplicates in all fields

[macroapa]

Hi,

How do a write a query that will identify duplicate records in a table
where all fields in the record are identical (and delete the dups so
just one remains).

I need to merge 2 tables that may contain duplicate records.

Thanks.

 

[Tom Wickerath]

You can use a UNION query to accomplish this, as long as all fields in the
record are truly identicle.

http://www.accessmvp.com/TWickerath/downloads/unionqueries.zip

Do not use the ALL keyword (ie. UNION ALL) or else you will get the
duplicates.


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________