Sum in a report

[Rossella]

Hi all,I'm a new user of Access reports and I need your help.
I've a column named Product Period then A B and Sum(of A and B)
I need to create the sum of the values of A and the sum of the values
of B and then the sum of of all the A and B.

Just to explain (this is what I've got now)


Product Period A B Sum
bla 1-20 100 50 150
ewew 1-20 20 30 50
rere 21-31 35 15 50
sdsdd 21-31 20 10 30

I'd like to have

Period Sum of A (per period) B (sum per period)
Sum
1-20 120 80
200
21-31 55 25
8o


Total 280


I'd like the products not to be visible at all!
Is it possible?

 

[James Kendall]

If I understand it correctly it sounds like you just want to see the sums per
period.
Some suggestions on how you can accomplish this:
1 - Just take out the "product" field in the report,
2 - Change the text color to the background color of the report (visually
cloaking it),
3 - or Take the query you are using and remove the field "product" from it
then make a report from that query.