Information input on form to be shown on report

[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!

 

[PWise]

put 2 text boxes on your report header named

startdate
enddate

and in the for open

me.startdate = forms!formname!startcontrolname
me.enddate = forms!formname!endcontrolname

change fromname to the name of your form

 

[GingerR]

On the report, put a text box with something like

="Dates from " & [Forms]![FormName]![txtStartDate] & " to " & [Forms]![FormName]![txtEndDate]

where txtStartDate and txtEndDate are the names of your text boxes on your form ("FormName").

So this will end up saying

Dates from 1/1/08 to 3/31/08.

actually they'll probably say "2008" unless you put FORMAT() around them.

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244. Basics at

http://r937.com/relational.html