Printing query parameters on reports

Gkirkup

Registered User.
Local time
Today, 14:58
Joined
Mar 6, 2007
Messages
628
I have a report that runs from a query. The query has a date range entered as two parameters. How can I print those two parameters (the start date and end date) on the report?

Robert
 
I have a report that runs from a query. The query has a date range entered as two parameters. How can I print those two parameters (the start date and end date) on the report?

Robert

Insert a Text Box in your report and in the Control Source properties of that box type the parameter as you have it in the Query, enclosed in square brackets eg [start date]. Actually, probably better to copy & paste so that you don't make any typing errors!

George
 
Last edited:
Thanks, I'll give that a try.

Robert
 

Users who are viewing this thread

Back
Top Bottom