Totals in A Report

J

Jenn

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

¿How to divide a total into 0
Two Totals from the same column 2
Another Running Totals Problem 9
Cross Tab Quert Totals 4
Calculated Item causes undue repitition in pivot table 2
How to dynamically add up varying # of cells base on a value 6
Adding data from multiple cell and linking to a new worksheet 3
Grand Total for Rows not Working in a Pivot Table 1

Top