Sales Summary

[tsison7]

I have a table with sales figures dated from 2005 to current. I'd like a
report to show the following:

Sales for each year 2005, 06, 07
Total of sales to date
Total of sales last month
Total of sales last 3 months

I can do the first 2 no problem but I would I incorporate sales over the
last n months?

 

[Duane Hookom]

Sales over the last three months could be calculated in a header or footer
with an expression like:
=Sum(Abs([SalesDate]>=DateAdd("m",-3,Date())) * [SalesAmount])