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?

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" wrote:

> 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?

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.

"mscertified" wrote:

> 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" wrote:
> 
> > 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?