Report w/ date range issue...

[Shawn12]

I have a report that has 2 subreports in it. In order for the subreports to run you have to enter a date range that come from the query. Is there a way that I can set an [Event Procedure] so that it sets the date range the same for both subreports?

Something like this..this doesnt work but something similar would be great...


Private Sub Report_Open(Cancel As Integer)

Me.ConversionPctPHX.[enter start date] = Me!ConversionPctSTP.[enter start date]
Me.ConversionPctPHX.[enter end date] = Me!ConversionPctSTP.[enter end date]


End Sub

 

[SkipVought]

Hi,

Date RANGE???

Me.ConversionPctPHX.[enter start date] =< Me!ConversionPctSTP.[enter start date]
Me.ConversionPctPHX.[enter end date] >= Me!ConversionPctSTP.[enter end date]

depending on which date is aociated with the SOURCE data.

Skip,

_[red][/red]

 

[SkipVought]

...adn possibly...

Me.ConversionPctPHX.[enter start date] =< DateValue(Me!ConversionPctSTP.[enter start date])
Me.ConversionPctPHX.[enter end date] >= DateValue(Me!ConversionPctSTP.[enter end date])

Skip,

_[red][/red]

 

[Shawn12]

Heres what happens..

I open the report it asks me [Enter Start Date].. I enter it..
Then it asks me [Enter End Date]..I enter it.. That is for ConversionPctPHX..

Rinse and repeat for ConversionPctSTP..

Im trying to make it only ask [Enter Start Date] and [Enter End Date] 1 time, rather than 2. The Above I have tried and it just says it doesnt support it.

The [Enter Start Date] ans [Enter End Date] are in the Query as a Where Statement. So Im not even sure that I can set this parameter in the report.