Thread: Duplicates
View Single Post
  #1  
Old March 2nd, 2010, 05:26 PM posted to microsoft.public.access.queries
gil_wilkes
external usenet poster
 
Posts: 20
Default Duplicates

In a query how can I check for duplicates in 3 different fields. The
duplicates could be in field 1 and field 2, field 1 and field 3 or field 2
and field 3 or Field 1 and field 2 and field 3. I can find duplicates in any
one field, but not in a combination of others.
Thanks for your help in advance.