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.
 
You must log in or register to reply here.

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

Call stored procedure in SSMS from Access 2016 doesn't work. 0
Creating a "Greater Than Date" criterion 2
Access Creating names from fields in access database. 0
update time value issue 7
Convert Text field to Date field within existing database 6
Access stripping decimal places in query 1
Am I disturbing a machine in production floor if I access its database remotely? 4
Creating a Query based of two diffent data tables 1

Back
Top