Group Footer - print totals when value changes

  • Thread starter Thread starter rick allison
  • Start date Start date
R

rick allison

This is probably really easy but I'm having brain freeze.

I have the following information:

Title, 4", 8", Class
STD1 1 1 STD
STD2 2 2 STD
JWW1 3 3 JWW
JWW2 2 2 JWW

I need a report that shows

Title 4" 8"
STD1 1 1
STD2 2 2
STD Total 3 3
JWW1 3 3
JWW2 2 2
JWW Total 5 5
Total 8 8

I can't for the life of me figure out how to print STD Total or JWW Total.
I've set up a group footer on class but it prints between each class.

Thanks,

Rick
 
Do you Sort/Group on Title prior to your Sort/Group on Class? Make sure your
first sorting and grouping level is Class.
 
Printing between every class is exactly what you what. You need text boxes
with =Sum([4"]) or =Sum([8"]) as their ControlSource property (complete with
the equal sign). To get the overall total at the end, copy those text boxes
to the Report footer.
 
Thanks, that the tip I needed. I knew it was something simple.

Rick

-----------------------------------------
 
Thanks, I did that and the report is perfect.

Rick

-----------------------------------------------

Douglas J. Steele said:
Printing between every class is exactly what you what. You need text boxes
with =Sum([4"]) or =Sum([8"]) as their ControlSource property (complete
with the equal sign). To get the overall total at the end, copy those text
boxes to the Report footer.

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)


rick allison said:
This is probably really easy but I'm having brain freeze.

I have the following information:

Title, 4", 8", Class
STD1 1 1 STD
STD2 2 2 STD
JWW1 3 3 JWW
JWW2 2 2 JWW

I need a report that shows

Title 4" 8"
STD1 1 1
STD2 2 2
STD Total 3 3
JWW1 3 3
JWW2 2 2
JWW Total 5 5
Total 8 8

I can't for the life of me figure out how to print STD Total or JWW
Total. I've set up a group footer on class but it prints between each
class.

Thanks,

Rick
Click to expand...
Click to expand...
 
Back
Top