Paul

To add to Rick's and John's suggestions, I would ask a clarifying question.
What data type are you using to hold the "time" values. I'm unaware of an
Access datatype for "time" only.

--
More info, please ...

Jeff Boyce
Access MVP