Summation of specified data in a grouping?

[bluke]

I built a report that gives a summation for the entire data range specified by grouping. Sum([Sales]) for each group. This totals the entire data range, for example April 1st through april 30. what expression can be used in addition to this one on the same grouping level to give a summation of actual sales to date. for example April 1 through april 14 on the same grouping level as the entire report range?

Thanks

bluke

 

[ajetrumpet]

this might help ya a little bit.

http://www.access-programmers.co.uk/forums/showthread.php?t=157264&highlight=previous+time+periods