Access 2000 Reports

L

Luke

Does anybody know an easy way to print the record
selection criteria(from a query) in the header/footer of
a report. Not just the SQL statement, but also any
parameters entered by the user when running the report.
Thanks!
 
D

Duane Hookom

If you would like to display the query parameters in the report, then create
a text box with a control source like:
="Dates from " & [Enter Start Date] & " to " & [Enter End Date]
 
F

fredg

Does anybody know an easy way to print the record
selection criteria(from a query) in the header/footer of
a report. Not just the SQL statement, but also any
parameters entered by the user when running the report.
Thanks!
Click to expand...

Duane told you how to print the actual parameters.
Did you also wish to print the actual SQL?
If so, as control source in an Unbound control:

=reports!reportname.recordsource

Notice that there are NO quotes around the report name.
 
L

Luke

Thank you,
Between you and Fred I got exactly what I need!
-----Original Message-----
If you would like to display the query parameters in the report, then create
a text box with a control source like:
="Dates from " & [Enter Start Date] & " to " & [Enter End Date]

--
Duane Hookom
MS Access MVP
--

Does anybody know an easy way to print the record
selection criteria(from a query) in the header/footer of
a report. Not just the SQL statement, but also any
parameters entered by the user when running the report.
Thanks!
Click to expand...


.
Click to expand...
 
Top