Return unique records

Anita · Jul 22, 2005

What criteria would I use to retrieve unique records only from a table using
a query?

Any help appreciated. The version is 2000.

Many thanks

Anita

Dennis · Jul 22, 2005

With your query open in design mode, right click in any blank area in the top
half of your query design. Select properties & change Unique Records to Yes

Anita · Jul 22, 2005

Thanks Dennis !!!

Dennis said:
With your query open in design mode, right click in any blank area in the top
half of your query design. Select properties & change Unique Records to Yes