Parameters in Report

  • Thread starter Thread starter Carol
  • Start date Start date
C

Carol

I have a report based on a query, and now would like to
add parameters/prompts for the user without going back to
the original query and adding them there.

Is there a way to add parameters to the report without
changing the original query and having to re-create the
report?

Thanks for the help.
 
I have a report based on a query, and now would like to
add parameters/prompts for the user without going back to
the original query and adding them there.

Is there a way to add parameters to the report without
changing the original query and having to re-create the
report?

Thanks for the help.
Click to expand...

Where did you get the idea that adding parameter prompts to a query
would require you to re-create the report?

if you wish to limit the report to a certain period of dates, in the
query that is the report's record source, write, on the DateField's
criteria line:
Between [Start Date] and [End Date]

Save the changes.
When the report runs it will prompt for the 2 dates.
 
Back
Top