One date band to control all 3 sub reports 2

[SamDemon]

I have a report (rptGroupSummaryAll) that contains 3 sub reports:-

rptGroupSummaryQuote
rptGroupSummaryConfirmed
rptGroupSummaryTicketed

At the present moment in time the first two sub reports are filtered on the 'DateOfEnquiry' field and the last (rptGroupSummaryTicketed) is filtered on the 'TicketedOn' field.

Is it possible to have the user enter one set of date ranges that controls all three reports?

Normally i would do it using the following expression in the qry criteria:-

Between [Enter Start Date] And [Enter End Date].

But using the above method means that 3 lots of date ranges have to be entered for the one report.

Thanks in advance!

Sam

It's just common sense, shame sense isn't common!

 

[lupins46]

Create a form containing a button to run your report.
Add two textboxes to the form for your startdate and enddate values.
Modify your report queries to use the form textboxes instead of [ ... ] parameter fields.
between Forms!myformname!mystartdatetextboxname and
Forms!myformname!myenddatetextboxname

 

[SamDemon]

Hi Lupins46,

Thank you for the post! I am still having a little difficulty getting it to work. Let me tell you what i've done so far.

I have created a form called frmGroupSummaryDateParameters which has the following contain on it:-

2 x text box - GroupSumStartDate & GroupSumEndDate

1 x button - controlled my a macro, mcrGroupSumParamRun

The macro has been created with the following criteria:-

Action - OpenReport
Report Name - rptGroupSummaryAll
View - Print Preview
Window Mode - Normal

On the main report (rptGroupSummaryAll) I have adjusted all the sub reports queries to contain the following parameter:-

Between [Forms]![frmGroupSuumaryDataParameters]![GroupSumStartDate] And [Forms]![frmGroupSuumaryDataParameters]![GroupSumEndDate]

Sorry to be a pain but I'm a little unsure where to look.

Sam

It's just common sense, shame sense isn't common!

 

[lupins46]

You don't say what is going wrong....

'I have created a form called frmGroupSummaryDateParameters '

which is not the spelling you have used in your criteria...

Between [Forms]![frmGroupSuumaryDataParameters]![GroupSumStartDate] And [Forms]![frmGroupSuumaryDataParameters]![GroupSumEndDate]

 

[SamDemon]

I feel so silly!

Thanks!!

Sam

It's just common sense, shame sense isn't common!