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.
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.