Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Parameter criteria displayed in report 1

Status
Not open for further replies.
Mar 17, 2003
2
GB
I have written reports that require the user to enter date criteria (for example) to select certain records.

How can the two dates (start and end - which the query demands) that the user is prompted to enter be displayed on the actual report that is produced?

Many thanks - GenSec
 
Add a text box to your report header with its control source something like this:
Code:
= "For the dates " & [Your first parameter] & " to " & [Your second parameter]
 
Thank you for your quick response CosmoKramer - it appears you mean for me to enter these in manually, I take it that this method would not read from the users input automatically, or would it?

Thanks in advance - GenSec
 
Yes, the users input will appear...Replace what I entered as parameters with your actual parameters (spelled exactly the same). They will then be passed to the report with the values the user entered....
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top