distinct key word

I

inungh

I always need change to SQL mode create distinct queries.
I just wonder is it possible to create disctinct query in design mode
that I do not need switch to SQL mode to modify my SQL statement?


Your information is great appreciated,
 
A

Allen Browne

In query design view, open the Properties box.
Set Unique Values to Yes.

(If you don't see the property, make sure you are examining the properties
of the query, not of a table or field.)
 
K

Klatuu

In the upper pane of the query builder, right click and select properties.
Find the Unique Values property and select Yes.
 
Top