Hello, I need to query a database for records that fall between 23:00 and 06:00 and I used the following in the query field criteria box:
Between #11:00:00 PM# And #6:00:00 AM#
This returned records between 06:00 and 23:00.
In other words I got the records that occurred during the day but I need the records that occurred during the night. What am I missing?
Thanks,
Rick
Between #11:00:00 PM# And #6:00:00 AM#
This returned records between 06:00 and 23:00.
In other words I got the records that occurred during the day but I need the records that occurred during the night. What am I missing?
Thanks,
Rick