Compare and display non dups

  • Thread starter Thread starter Guest
  • Start date Start date
You could use a duplicate query. Define the fields where the duplicates are.
Run the result. You should now see all the duplicates. Reverse the proces by
setting the criteria in the count column which states > 1 to < 2 this will
show only the records where the count is 1. Notice the caption because access
will show you the caption "number of duplcates" which you might want to
change to your own caption.

Just remember that it is important in this case which fields you designate
because they all have to be the same.

hth
 
Do you mean you want to show all records in table one that are not in table
two and all records in table two that are not in table one?

If so, you can use the unmatched query wizard to build two queries. One for
each of the above. If the structures are identical, then you could combine
the two queries into one using a UNION query.

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..
 
Back
Top