Access Duplicate Query Wizard

[mksolutions]

I am running Access 2003, and have it set up to look at a SQL database. I see articles all the time showing how to use a wizard to find duplicate data. I can not find that option in my Access. I have installed all the options, etc. Is it because I am using a project instead of an access database? If so, how can I search for duplicates in a project?

Thanks!

 

[PHV]

SELECT duplicatable fields list
FROM yourTable
GROUP BY duplicatable fields list
HAVING Count(*)>1

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