Pass-Through Query Appends Current Date to Time Column

[raynman1972]

This is probably something silly, but I can't figure out how to fix this. I have a pass-through query that should only show time values in one of my columns and this holds up in MySQL Query Browser (ie: the text file export has only time values), but when running the same query in Access as a pass-through, I get today's date appended on the front of my time values.

For example, '06:00:00' becomes '8/12/2012 6:00:00 AM'.



This wouldn't be a huge deal, but I need to do less/greater than measurements on the time values and '06:00:00' does not equal '8/12/2012 6:00:00 AM'.

How do I fix this?

[orange]

What does a Time only field mean exactly? Just curious when I consider 10:15 AM -- don't I want to know which day (Date) we're talking about? I'm just not understanding the context of a Time only field?

The incoming text file must have some default or implied value to you and your program.

[raynman1972]

This is for worker schedules which persist week-over-week indefinitely until something is modified. So if John D. works 08:00-17:00 on Monday, this is true for every future instance of a Monday until there is a change- so date is not necessarily important. What I want to be able to do is measure the number of agents that start at 08:00 and I can't do this because Access is adding the current date in front of my time.

To really break it down, I want to count the number of rows that are greater than or equal to 08:00 via VBA for hundreds of employees and I can see the issue of the date being a problem.