Access 2000 Reports

[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!

 

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

 

[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!

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.

 

[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!

.

 

[Guest]

Thank you. Between you and Duane I got exactly what I
need!