querying sql server from access

[Jackson]

I've created a odbc link to a sql database from access (through file->Get
external data -> link tables), when I run a query in access and specify a
date range for a date field it (<=#11/30/2005# and >=#11/1/2005#) returns
everything that has a date field.

Am I allowed to query a sql database in Access? Or is it that I'm not
allowed to do date ranges using an odbc link?

TIA,

Jackson

 

[Dirk Goldgar]

I've created a odbc link to a sql database from access (through
file->Get external data -> link tables), when I run a query in access
and specify a date range for a date field it (<=#11/30/2005# and

Am I allowed to query a sql database in Access? Or is it that I'm not
allowed to do date ranges using an odbc link?

There shouldn't be a problem. Would you care to post the complete SQL
of the query?

 

[Jackson]

Thanks for responding back so quick,

I decided to create the link again and I think I might have indexed the
table differently b/c I was able to get the information I wanted from the
query.

Thanks again Dirk,

Jackson