Totals in A Report

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

Guest

Access Question
I have a report based on a query that shows information based on a Fiscal
Year (FY). Below is an example:

Raw Material Marketing
FY2001
Product A $200 $200
Product B $300 $400

FY2002
Product A $400 $500
Product B $300 $400

What I would like to add is the total Raw Material Cost and the total
Marketing Cost Per FY (Fiscal Year). (Like below)


Raw Material Marketing
FY2001
Product A $200 $200
Product B $300 $400
Totals: $500 $600

FY2002
Product A $400 $500
Product B $300 $400
Totals $700 $900

Can any one tell me how to create these total sums per Fiscal Year (FY)?
Thanks.
 
Back
Top