Duplicate query

[Paul Wilson]

I have 2 databases which have data, I wish to check one database against the
other for duplicate records using a specific number sequence assigned to each
record. But this number sequence is not an ID field. I wish to write all non
duplicates from this database to a new list?

I'm still new to access and don't know how to approach this.

 

[John Spencer]

The field you join on does not have to be an id field. As long as you
wish to identify records in two tables that have the same values in a
field (or fields), you just join the two tables on those fields. If
there is already a join set on the ID field then delete that join.

To delete the join - right click on the join line and select delete

To set a join - drag from the field in the first table to the
corresponding field in the second table. Repeat if more than one field
is involved in determining the duplicates.

Select the fields you want to display and run the query.

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