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?

On Thu, 16 Mar 2006 15:55:27 -0800, trainer07
<(E-Mail Removed)> wrote:

>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

"trainer07" <(E-Mail Removed)> wrote in message
news:44266EED-2B4E-4449-AAEF-(E-Mail Removed)...
>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?