Adding a Date Range to a Report

  • Thread starter Thread starter RS
  • Start date Start date
R

RS

I would like to be able to add a date range to a report each time I create a
new instance of the report. Right now I have it set up to the report is tied
to a parameter query that allows me to enter a beginning date and an end
date.

Is there a way that I can have that date range appear at the top of the
report automatically each time I create a new report with the new set of
dates?

Any help would be much appreciated!!
 
You should really have a single report that allows users to enter criteria in
controls on a form. IMO, parameter queries are not appropriate user interface.

You can display the criteria on your report with text boxes with control
sources like:
="From " & Forms!frmDates!txtStartDate & " to " & Forms!frmDates!txtEndDate
 
Back
Top