Using a General Date in a query criteria. Access 2002

[Edward_]

First I must say, I'm trying to test this issue in a Query, but things will end up in an SQL string in my VB app.



I have been using a concatenated date + time(like below) for a few weeks in a test application with no issues, when suddenly today the query pulls random Sept (2, 3, 4, 5, 6, 7, 8, 9) 2015 dates rather than between to explicit dates. (ie. 9/9/2015 7:00:00 AM and 9/10/2015 7:00:00 AM)

So in my test query I have a Time_In field (with data like: 9/3/2015 11:32:33 PM) and I'm trying to find the syntax for the criteria. Something like Criteria: Between "9/9/2015 7:00:00 AM" And "9/10/2015 7:00:00 AM" is pulling random dates.

Any advice appreciated.

[ssanfu]

Would have to see the SQL of the query, but are you delimiting the dates with the hash marks (#) in the query?

[Edward_]

Thanks

I just tested: Between "#9/9/2015 7:00:00 AM#" And "#9/10/2015 7:00:00 AM#" which gives no results (of 40-60 possible).

Here is the SQL of the current test query:
SELECT tblData.Room, tblData.Dr, tblData.Group, tblData.Label, tblData.Time_In, tblData.Time_Out, tblData.Elapsed
FROM tblData
WHERE (((tblData.Time_In) Between "#9/9/2015 7:00:00 AM#" And "#9/10/2015 7:00:00 AM#"));

Access added the quotation marks.

[Edward_]

The DB fields were Text rather than DateTime.
Changing them to DateTime made everything work.