Parameters as part of the report

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

Guest

How can I get the parameters that are entered in a report to also display as
part as the report? For example, the users enter the dates between 1/1/05 to
3/1/05, how can I get this to print on the report?
 
This depends on where the users enter the dates? If this is a parameter
query, you can bind the parameter to a text box like:
=[Enter Start Date]
Or
="Report for dates from " & [Enter Start Date] & " to " & [Enter End Date]

If the criteria come from a control on a form (much preferred), use
something like:
="Report for dates from " & Forms!frmDates![txtStartDate] & " to " &
Forms!frmDates![txtEndDate]
 
The parameter is actually entered in the Query that is used for the report.
So on the form when you click on the command button to open the report, the
macro, prompts for the dates, when it opens that query. Then on the report
itself I have the title - Average from [enter start date] to [enter end
date], so the user has to enter the date twice.

Any suggestions?

Duane Hookom said:
This depends on where the users enter the dates? If this is a parameter
query, you can bind the parameter to a text box like:
=[Enter Start Date]
Or
="Report for dates from " & [Enter Start Date] & " to " & [Enter End Date]

If the criteria come from a control on a form (much preferred), use
something like:
="Report for dates from " & Forms!frmDates![txtStartDate] & " to " &
Forms!frmDates![txtEndDate]

--
Duane Hookom
MS Access MVP
--

lbradley said:
How can I get the parameters that are entered in a report to also display
as
part as the report? For example, the users enter the dates between 1/1/05
to
3/1/05, how can I get this to print on the report?
Click to expand...
Click to expand...
 
If you entered the prompts exactly the same, you should not be prompted
twice. Make sure you typed them exaclty.

--
Rick B



lbradley said:
The parameter is actually entered in the Query that is used for the report.
So on the form when you click on the command button to open the report, the
macro, prompts for the dates, when it opens that query. Then on the report
itself I have the title - Average from [enter start date] to [enter end
date], so the user has to enter the date twice.

Any suggestions?

Duane Hookom said:
This depends on where the users enter the dates? If this is a parameter
query, you can bind the parameter to a text box like:
=[Enter Start Date]
Or
="Report for dates from " & [Enter Start Date] & " to " & [Enter End Date]

If the criteria come from a control on a form (much preferred), use
something like:
="Report for dates from " & Forms!frmDates![txtStartDate] & " to " &
Forms!frmDates![txtEndDate]

--
Duane Hookom
MS Access MVP
--

lbradley said:
How can I get the parameters that are entered in a report to also display
as
part as the report? For example, the users enter the dates between 1/1/05
to
3/1/05, how can I get this to print on the report?
Click to expand...
Click to expand...
Click to expand...
 
Back
Top