Easy One: How do you display the Parameter Input?

Hello,

When you create a parameter-driven query (one that prompts the user to enter a condition, say a date range) how do you get that users input (here, the date) to display on your report?

Thanks in Advance!!

What do you mean? What are you using? ADO? Access? If you are just using straight Access then put the following in the query that your report pulls from:
In the Criteria section just put' =[What do I want to prompt the user for here]

If you are using something like the data environment in VB then just put a Textbox or whatever on the form and then when you execute the query use:
de.qWithParam Text1.text

Edneeis,

Thanks for replying. I am using Access 2000. The query asks the user to enter a "date range". That part works. But what I need to know is, how do I get the "date range" that the user entered into the query to display on the report? When the user runs the report, and the query prompts them to enter a date range, I need the report to show that date range. That way, the user will know what date range the report was run for. Can this be done? Thanks for your help!!

I've done that before...it sounds easy, but it was difficult to get the variables into the report...

I eventually used the MIN and MAX functions of my date field to show the date range for the report

Hope this helps

Tom

If it's any help I did this within the onload event of the report using VBA to prompt for the variables and passing this through to the query - sounds simple but took a bit of playing with to get it right