show values that appear once only

[Jas]

Hi - I have an access database with over 400,000 entries and need a query
which will display those values that appear in the database only once. For
example, if my database hase the following entries:

a
b
b
c
c
d
e

then I need a query that will return only:

a
d
e

becasue these are the characters that appear only once in the list. Can
someone help??

 

[Dennis]

In design mode of the query, put your column in twice. Click on the Group
by/Totals button on the toolbar. Change the 2nd column from group by to count
and enter the criteria of 1.

 

[Jas]

Thanks Dennis - that works just how I want it to!