How do you run a non duplicate query to find non duplicate record

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I know how to use the Duplicate Query Wizard to find duplicate records in a
table, but how would you run a query to find non duplicate records in a table?
 
I know how to use the Duplicate Query Wizard to find duplicate records in a
table, but how would you run a query to find non duplicate records in a table?

Create a Query grouping on the fields which constitute "a duplicate" -
all the fields in the table if need be; select the Primary Key field
in addition to the group fields, and use Count as the aggregate
function.

Put a criterion of 1 on this count to select the records which have
one and only one record in the "group" - these are the nonduplicates.

John W. Vinson[MVP]
 
Simplest way is to use the dup wizard & Edit the SQL, Changing HAVING
COUNT(*) > 1 to HAVING Count(*)=1

Another way is to make a new Query with an outer join to the Dups query &
Exclude them from the result ...

HTH

Pieter
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top