Putting query prompt on Report (2003)

Topic

New Reply

My query prompts for days from today to fetch records from a helpdesk tickets database. I wish to put in the report the number of days that the user requested in the prompt and need help specifying this (nameless?) variable.

Reply | Quote

Replies

In my haste I asked a wrong question — How do I get this no. of days entered to display on the report?

Reply | Quote

Your query has a parameter of the form

[Enter number of days]

You can use the same expression in the Control Source property of a text box on your report:

=[Enter number of days]

or, if you want to incorporate it into some text:

=”Report for ” & [Enter number of days] & ” days”

You must use exactly the same text between the square brackets [ ] as in the parameter prompt.

Reply | Quote