distinct key word

  • Thread starter Thread starter inungh
  • Start date Start date
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,
 
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.)
 
In the upper pane of the query builder, right click and select properties.
Find the Unique Values property and select Yes.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Insert a crosstab to temp table 4
SELECT DISTINCT query 8
disctinct query memo field 3
Selecting Distinct Memo Fields 1
COUNT DISTINCT ? 5
Access 2003 truncates code in queries 3
select distinct 1
Select Distinct Query 6

Back
Top