Access 2007 Query of unique values

[Norm]

I am working with an ODBC connection to an SQL database. In attempting to
create a simple query for unique values in a field, I would expect to right
click in the quey and request properties. The only information that appears
in the property sheeet is the data source name. Is it a problem with the
ODBC connection?

 

[mscertified]

You need to know what tables and columns are in the database you are
connecting to. I dont think Access can tell that since its not within the
Access database.

-Dorian

 

[Norm]

Perhaps my question was misleading. With previous versions of access, I was
able to set the property of the query to unique values and when I try to
perform the same request I do not see this as an option. The tables are in a
SQL database. I am using and ODBC connection to the tables.

 

[Carlos Cortez]

in the design view click on the propperty sheet
If this doesn't show the query properties, click on the area below where you have set your fields and filters, this will show the query propperties

 

[Bob Barrows]

You're responding to a question that was asked more than 3 years ago. You're
a little late ...