View Full Version : Adding Date Parameters to a Report


Joy_Cooper
10-14-2010, 01:42 AM
I have a created a report in an Access Database which is run from the parameters a user selects in a form. The user has the option of selecting a start and end date from two combo boxes on the form which are linked in the query under the same field:

Between [Forms]![Serial Report Selector]![Combo16] And [Forms]![Serial Report Selector]![Combo18]

How can I include these start and end dates in the report heading? The start date is picked up from Combo16 on the report as:

=Format$([Actual Visit To Unit],"dd mmmm yyyy",0,0)

.... but I cannot work out how to apply the date contained in Combo18 to the report.

Many thanks

vbaInet
10-14-2010, 01:53 AM
Just as you're pointing to the combo boxes in the query, do the same in a textbox located in the report's Header section.

Joy_Cooper
10-14-2010, 02:30 AM
Thank you. It's obvious really, sorry I'm a bit rusty.

vbaInet
10-14-2010, 03:02 AM
No harm in asking when you're not sure. You just needed a nudge in the right direction. :)

Glad you solved it.