Report totals - breakdown by month, quarter, & year

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I am using Access 2000. I have a sales table that contains fields for
invoice date and invoice amount. I want to create a report that shows sales
totals for a three year period. I'd this report to be in a grid format that
not only shows the three year total, but also shows the breakdown by month,
quarter, and year.

I am trying to find the easiest, most efficient way to do this. If anyone
can give me any advice to point me in the right direction, or tell me where I
can find a good example, I'd really appreciate it.

Thanks,
Paul
 
SELECT Sum(Abs(Year([InvoiceDate])=Year(date())) * [InvoiceAmt]) As YTD,
Sum(Abs(Format([InvoiceDate],"yyyymm")=Format(date(),"yyyymm")) *
[InvoiceAmt]) As MTD,
[YouShouldBeAbleToDoTheOtherIntervals]
FROM tblSales
 
Back
Top