Query for removing duplicate entires

  • Thread starter Thread starter Steve
  • Start date Start date
S

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?
 
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
 
Back
Top