I am just building a simple database for ordering glucose readings.
glucose.accdb
I have three queries to start with.
Morning Between #8:00:00 AM# And #12:00:00 PM# (Criteria for Time Field, works fine returns correct data)
Afternoon Between #12:00:00 PM# And #6:00:00 PM# (Criteria for Time Field, works fine returns correct data)
Evening Between #6:00:00 PM# And #1:00:00 AM# Doesn't work right returns values outside the parameter
I have attached the database, hard for me to figure out what is happening.
Database also available here if the attachment didn't work (new to forum) http://mcltech.com/access/glucose.accdb http://mcltech.com/access/glucose.accdb
If you run the queries you will see what I mean, in the Evening Query there are times from everywhere