I actually was in a class where the instructor used date/time as a field and he never mentioned it could cause errors.
I'm amazed by how many times we see such things being taught/used by instructors. In another current post in this forum, an exam question uses the word Name as a table field in a query. Who's teaching the teachers?? Along that line, what you've been given as a solution pertains to what is known as filtering the record source.
Just looking at it as is, makes no sense.
If you're a computer, you're trying to divide Date by Time (Date/Time). Never going to work.
FYI
Naming conventions
- http://access.mvps.org/access/general/gen0012.htm
- https://www.access-programmers.co.uk...d.php?t=225837
- http://allenbrowne.com/AppIssueBadWord.html
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.