Query for removing duplicate entires

[Steve]

I have two tables I will call A and B. A is a subset of B.
I need to run a query that will return all records that
are in Table B but are not in Table A. In other words, I
want the duplicate records, but I don't want to see them.
I want Access to figure out what the duplicate records are
and then make them go away so all I have left are records
unique to Table B. How do I structure the query to
eliminate the duplicates?

 

[Michel Walsh]

Hi,


Try the wizard query about finding unmatched record: the records in B that
have no match in A. Add a DISTINCT to remove duplicated results (or, through
the query properties, change its Unique Values to Yes).


Hoping it may help,
Vanderghast, Access MVP