Hello all,
Yes, I'm still working on this "time" query. With the help from all of you over the last few weeks this query has really made some progress. However today I noticed that I still have an issue with the time. In the table Time_1 is a var(Max) and then converted to a date in the Query.
When I query the data on Form "Cell 4 Device Query" for lets say 6:00am today until 4:00pm it shows nothing. But if I query the data for 6:00am to 9:59am it shows up just fine. Then again from 10:00am to 4:00pm it also shows up fine. But why will it not show the overall request from 6:00-4:00?
I've attached this section of my database. I'm hoping someone can help me with this.
Mike
DB 1.zip