Maybe I set this up wrong..

[DurhamCons]

I have a report that shows commissions over a certain payperiod. In this report, I have created a subreport that shows the YTD totals.

My boss wants to implement a bonus structure that will be tied to an average daily sales over the current quarter.

Currently, my query and report structure looks like this...

qryCommission > rptCommission (constains information between [enter start date:] and [enter end date:]) <-- Pay period
qrySubCommission > subrptCommission (contains YTD totals)

Should I create another subreport and query for the quarterly totals or is there an easier way to combine all of this? TIA.

 

[DurhamCons]

Thanks for your help.