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