Year To Date???

[hootie318]

My main report shows deliveries and types by month. At the bottom there is a subreport that totals everything for the year. However if you go back a month or two or three, etc the report show the total for the year, not up until that month. Any Ideas on how to total up up until the selected month?

 

[FoFa]

Make sure your subreport query uses the same end date as the main report.
Your main report must have a date criteria, use the same criteria in your sub query, basically.

 

[pbaldy]

Add the selected month into the WHERE clause of the subreport.