Between parameter on report

[AndeanWayne]

I have a report based on a query with a between two dates parameter (Begin date and end date). This parameter is fed from a form. All works well - query, form and report. My question is can the date parameter appear on the report header so users know the report was based on a start date of 1/1/2008 and an end date of 1//2009 for example?

 

[pbaldy]

Sure; at its simplest a textbox with a control source of:

=Forms!FormName.TextboxName

or you can concatenate both into a string.

 

[CJ_London]

Assuming the begin date and end date are on your form and the form is open when the report is run you can simply refer to them using something like

Form!MyForm!BeginDate

as the control source for an (otherwise unbound) control in your report

Alternatively in your report recordsource include the begin and end dates as columns as well as within the criteria and you can then use a bound control in your report

 

[AndeanWayne]

Thanks to you both. It works great. Tried something similar but a macro had the form closed. Now with the form left open I get exactly what I want.

 

[pbaldy]

No problemo.