Use date from query in report

  • Thread starter Thread starter jas0n
  • Start date Start date
J

jas0n

I base a report on a query that asks for the date to base the query on.

This is the query part that requests the date:-

PARAMETERS [What is the Cutoff Date] DateTime;

I want to show the date entered to show in the report header as in - Report
based on Date: X
 
The query exposes the parameter to the report, so you should be able to put
a text box on your report, and set its ControlSource to:
= [What is the Cutoff Date]
 
Allen Browne said:
The query exposes the parameter to the report, so you should be able to
put a text box on your report, and set its ControlSource to:
= [What is the Cutoff Date]

--
Click to expand...

That worked fine .. id tried it before but I have been just hitting enter
rather than entering an actual date into the field - its needs an actual
entry to show the date on the report.

Thanks.
 
Back
Top