I have an Access 2000 database that contains records on every call taken by my Help Desk staff in each calendar month. In each record is a single field that identifies the date/time the call was taken. The data is in the following format: 1/2/01 10:30:42 AM
My question is: how do I build a query that is based only on the time with no reference to the date? For example, I may want to query how many calls in the entire database were logged after 8:00 PM or how many were logged between 5:00 pm & 6:00 PM.
Thanks!
