Query Criteria not returning any records

[SgtSaunders69]

I have a 2010 database using tables linked (ODBC) to a SQL database. Table dbo_tasks has a time/date field with much data populated. When I open the table in DATASHEET view and using the built in MSAccess data filter tool select "EQUALS" and copy paste or type an exact date from data in the table (EXAMPLE: 9/16/2011 4:14:20 PM) into the CUSTOM FILTER box and click OK no data is returned. If I perform the same steps on a non-time data field I can get data returned. Any thoughts on wh the fiilters will not return data for the DATE/TIME field?

I can get the query to return dates if I use the criteria <#1/6/2009#. So my question then is .. how do I pass the date criteria in this format from a form text box to the criteria for the query. The method I've tried is to put =[forms]![formname]![fieldname] in the criteria field of the query, but how do I include / pass the required # syntax around the date criteria value to the query criteria? I've tried variations of =#[forms]![formname]![fieldname]#... but this does not work. What am I missing?

Thanks..

[hertfordkc]

A guess: Since you are able to filter on other fields, you may be neglecting some syntax requirements, e.g. use of # to delimit date values. I'm not sure the filter tool guarantees that syntax requirements are met.

[June7]

The built-in filter tool should deal with any syntax requirements. The # delimiter would be needed in an SQL query statement.

Unfortunately, I don't work with SQL database so can't speak to any compatibility issue for date values between Access and SQL.

Sgt, you say a date field without time part will work?