querying for the date and time

  • Thread starter Thread starter Allie
  • Start date Start date
A

Allie

I have a date and time stamp (DateOfEntry) on all records
entered in a table. How do I query using that field?
Example, I want all record that were entered on 8/15/04
between 9am and 10am.

Thanks
 
Set the criteria under the DateOfEntry field to
Betwee #8/15/2004 9:00 AM# AND #8/15/2004 10:00 AM#
 
Back
Top