Make Table with Single Occurences

[Marguerite Hall]

I want to create a one field table with only single occurences of the field.
When I did a Make Table Query with the field grouped, the query looked fine
but the table contained multiple occurences.

 

[Jeff Boyce]

Please post the SQL statement.

Regards

Jeff Boyce
Microsoft Office/Access MVP