General discussion

Locked

Running a Date/Time Query

By layland ·
I have Access 2000 and I need to creat a query at will look for all records for a week.
Example: Say 05/22/00 thru 05/28/00.
What is the criteria for that?
(The date/time feild looks like this:
5/23/00 1:51 AM)

This conversation is currently closed to new comments.

4 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Running a Date/Time Query

by Larry H. In reply to Running a Date/Time Query

In the Query Grid's criteria row for the date in question type:
BETWEEN #5/22/00# AND #5/28/00#

That will select from midnight to midnight of the respective days.

Collapse -

Running a Date/Time Query

by layland In reply to Running a Date/Time Query
Collapse -

Running a Date/Time Query

by Leehlc In reply to Running a Date/Time Query

If you want to be prompted for the dates everytime you run the query(instead of having them hard-coded as 05/22/00 and 05/28/00 or whatever: Type the following in the criteria for your date/time field.
Between [Enter start date] AND [Enter end date]

This will prompt you each time you run the query. You can put whatever text you want in the square brackets. You will not have to enter the time portion, it will assume midnight to midnight.

Collapse -

Running a Date/Time Query

by layland In reply to Running a Date/Time Query

Thank you for your time!

Back to Software Forum
4 total posts (Page 1 of 1)  

Related Discussions

Related Forums