Microsoft Query Criteria line

  • Thread starter Thread starter bergie777
  • Start date Start date
B

bergie777

I have a database that uses a date/time field, it's
called EntryDate, it records like this 8/20/2003 08:18:00
AM in this format, I need to be able to pull the date and
also a start time and end time from this field to give
the client a limited view of what happened between 2
times? Is this possible? I'm not an expert with Access, I
usually build my query and add an expression to the field
or add it on the Criteria line, in design view not SQL
view.
Any help will be appreciated
 
You have just the one field that contains both the date and time value.

In the query QBE grid, on that date field's criteria line, write:
Between [Enter Start Date and Time] and [Enter End Date and Time]

When you run the query, it will prompt for both times.
Enter for the starting time as:
8/20/2003 08:15:00 AM
Enter for the Ending time as:
8/21/2003 12:00:00 PM
to find records within that time frame.

Note: If you do not enter a Time value, Access
will assume midnight (00:00:00 AM).
 
Back
Top