Grouping and totals

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
 
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)
 
Back
Top