I have a field in a query called [senttoSAM] that is a date/time field and is set to general date, so that it shows the date and time. I need to do a filter that will filter out any times before 8 am and after 5 pm. I tried
Between #8:00:00 AM# And #5:00:00 PM#
But it filters out too many records. I tried doing a separate field that formatted [sendtoSAM] as a medium time but it still filtered out too many records.
What am I missing?