want date parameter to show in rpt

  • Thread starter Thread starter nydia
  • Start date Start date
N

nydia

i have a main report with 2 sub reports. the reports are
base off queries created. in 1 query(subreport) there is
a date field and i put in the date parameters
Between01/01/03 and 12/31/03. I want the criteria dates
to show on this report, how can i do this.
 
nydia said:
i have a main report with 2 sub reports. the reports are
base off queries created. in 1 query(subreport) there is
a date field and i put in the date parameters
Between01/01/03 and 12/31/03. I want the criteria dates
to show on this report, how can i do this.
Click to expand...


You can refer to the parameters in the report's record
source query by using a text box with an expression the
refers to the parameters the same way you would refer to a
field in the query.

E.g. if the query uses parameter prompts [Start Date] and
[End Date], you could use a text box expression like:

="Invoices from " & [Start Date] &" to " & [End Date]
 
Back
Top