Use date from query in report

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
 
A

Allen Browne

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]
 
J

jas0n

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.
 
Top