running a query based on a date that I enter

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I've created a query in access that shows me all records that have extended
past an agreed hire period. The query works based on the <Date() function
applied to the due date, however I would like to be able to enter the date I
want the query to calculate from rather than having it run only on the
current date.

Any help would be much appreciated.
 
tobacey,
I think you'll need a "parameter" query as the record source for your
report.
I'll use an example...
If I had a situation where I wanted to report on all records with a
DueDate later than one I entered, I'd place
[Enter Criteria Date]
as the criteria for the DueDate field in the query behind my report.

Now, when the Report runs, the query opens an Input Box with "Enter
Criteria Date", allows the user to enter a date, then opens the report with
the records filtered by the date criteria the user entered.

hth
Al Camp
 
Back
Top