Grouping and totals

G

George Schneider

I have a report that is grouped by dept where dept is a three digit code for example 101,102 etc. I can group that fine and get a subtotal per division. I want to be able to also at the end of the last set of dept. given a division subtotal as well. All the 100's would be one division, all the 2oo's another divison etc.
 
D

Duane Hookom

Add another sorting and grouping level "above" the dept level. This one
would group by only the first character of the dept.

--
Duane Hookom
MS Access MVP


George Schneider said:
I have a report that is grouped by dept where dept is a three digit code
Click to expand...
for example 101,102 etc. I can group that fine and get a subtotal per
division. I want to be able to also at the end of the last set of dept.
given a division subtotal as well. All the 100's would be one division, all
the 2oo's another divison etc.
 
M

Marshall Barton

George said:
I have a report that is grouped by dept where dept is a three digit code for example 101,102 etc. I can group that fine and get a subtotal per division. I want to be able to also at the end of the last set of dept. given a division subtotal as well. All the 100's would be one division, all the 2oo's another divison etc.
Click to expand...


Create a new group using the expression:

=(CLng(dept) \ 100) * 100

Then you can calculate the division subtotal in the division
group footer section using a text box withan ecpression
like:
=Sum(somefield)
 
Top