Group Footer - print totals when value changes

[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

 

[Duane Hookom]

Do you Sort/Group on Title prior to your Sort/Group on Class? Make sure your
first sorting and grouping level is Class.

 

[Douglas J. Steele]

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.

 

[rick allison]

Thanks, that the tip I needed. I knew it was something simple.

Rick

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

 

[rick allison]

Thanks, I did that and the report is perfect.

Rick

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

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)

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