Information Input on Form to be Shown on Report 1

[Mandyxoxo]

I have a dialog form that pops up to retrieve dates for a report. The form works and then takes the dates and generates the query based off of those dates just fine. However, the query only outputs a single Total and therefore the dates are in a subquery. I want the report to say on it which dates it is for. Since the form is grabbing the dates and the query is only outputting a Total and not a date, how would I get the report to reflect the dates chosen on the form.

Thank you in advance!

 

[SoCalAccessPro]

On the report, in say, a label, set the value to:

= forms!yourform.yourtextbox

The form has to be open, or Access will prompt you for the missing parameter.

Tyrone Lumley
SoCalAccessPro

http://www.socalaccesspro.com