Passing Prompt Variable from Query to Report

[sylvanst]

Hello all,

I have an Access Report that I want to prompt the user a specific date range to enter in the query.

When the user types the beginning and ending dates in. How to I pass that variable data so it displays in the report?

What syntax is used in the report to show this? I have the prompt in query working just fine.

Let me know if anyone has an easy answer.

Thanks,

Kent

 

[67peshawar294]

Sylvanst,
If the query is working correctly you should be able to set the reports "Control Source" to the name of the query.
When the report is opened the prompts will appear and then the report will be displayed.
jim