Sum in a report

  • Thread starter Thread starter Rossella
  • Start date Start date
R

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?
 
Rossella said:
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?

Sure. you need to group by period and sum on those groups. You also
may want to remember that you can make divisions in a report visible or not.
You can make controls visible or not.

If that is not enough to get you where you want to go. Come on back for
more details.

I don't always give a full answer as I may not have an example handy and
I fell in most cases it is better to give a hint of where to go and allow
you to find your way. I personally believe that is usually far more useful
than just an answer.
 
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.
 
Back
Top