remove duplicates

D

Daniel

Hello,

How can I make a query on a specific field of a column so that it return all
the values of the field but without showing duplicate entries?

Thanks,

Daniel
 
B

Baby Face Lee

Hi Daniel
If you right click somewhere in the Query Design Grid and select Properties
from the menu, you can change the Unique Records property to Yes.
Alternatively, if your query is counting records then show 'Totals' in the
grid and then select GroupBy.
HTH

Lee
 
Top