Microsoft Query Criteria line

[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

 

[Fredg]

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).