Date criteria minus 1

[Brian900]

I want to set up a query that will include the entered date and records for the previous day. For example; if the user enters 2/2/03, I want it to include records from 2/2/03 and 2/1/03. Does any one know how to enter this into the criteria?

Brian

 

[Jon K]

Set the Criteria:-
Between [Enter a date]-1 AND [Enter a date]

Declare the parameter:-
In query Design View, choose menu Query, Parameters...
Type the Parameter: [Enter a date]
Select the Data Type: Date/Time

 

[Brian900]

This worked. Thanks!

Brian