Problems with Query Using Time in Access 2003 (11.6355)

H

hallozone

We have a table that holds schedule data by tutor including in and out time.
We created a query to select records for a particular tutor, on a particular
day of the week, with in and out times between a particular time:

SELECT Schedules.Out, Schedules.[In], Schedules.Coach, Schedules.Weekday
FROM Schedules WHERE (((Schedules.Out)>#14:00#) AND
((Schedules.[In])<=#14:00#) AND ((Schedules.Coach)=379) AND
((Schedules.Weekday)=3));

This statement works in Access 2002. This statements doesn't work in Access
2003. In order for us to get this to work, we had to run this statement
instead (with the :01's added):

SELECT Schedules.Out, Schedules.[In], Schedules.Coach, Schedules.Weekday
FROM Schedules WHERE (((Schedules.Out)>#14:00:01#) AND
((Schedules.[In])<=#14:00:01#) AND ((Schedules.Coach)=379) AND
((Schedules.Weekday)=3));

Has anyone experienced this problem before? Is it proper to add the :01's?

David
 
Top