Access 2000 date field

  • Thread starter Thread starter Mark Bellman
  • Start date Start date
M

Mark Bellman

I have an Access 2000 database that is using linked
tables to SQL 2000. I am trying to get a query to work
where I want to filter a datetime field from SQL Server.
I have tried putting the # symbols around the date in the
query and it does absolutely nothing. This query was
working properly when the table was an Access 2000 table,
but now that the table resides on SQL Server I cannot get
anything to work.

thanks,

Mark
 
Post the SQL of your Query and whether you are using it on the ODBC-linked
Tables or as a Pass-Through Query.
 
Back
Top