find dup query

[Huckfinnn]

How can I find dups or cross over in upto 5 or more access tables?
Should I import all into the same table, then run find dup query? And how would I do this.

 

[PHV]

Or comparing the difference between an UNION and an UNION ALL query.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[Huckfinnn]

I'm not sure I understand what a UNION query is.
I haven't used access much for almost a year so I'm a little rusty.
How do I run a find dup query?
I'm running access 2000.

thanks for any input.

 

[PHV]

Feel free to do a keyword search as this topic has been discuted several times.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244