Return unique records

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

Guest

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
 
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
 
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
Click to expand...
 
Back
Top