Report SubTotals

  • Thread starter Thread starter Bill
  • Start date Start date
B

Bill

I would like to be able to use subtotals in my report to
create a percent value on each detail line. My report now
shows a percentage column that is based from the Grand
Total. I would like for it to be based on the Subtotal
value.
 
Bill said:
I would like to be able to use subtotals in my report to
create a percent value on each detail line. My report now
shows a percentage column that is based from the Grand
Total. I would like for it to be based on the Subtotal
value.
Click to expand...

What subtotal value?
 
-----Original Message-----
Bill said:
I would like to be able to use subtotals in my report to
create a percent value on each detail line. My report now
shows a percentage column that is based from the Grand
Total. I would like for it to be based on the Subtotal
value.
Click to expand...

What subtotal value?
--
Marsh
MVP [MS Access]
.
My report shows percent of maintenance hours of grand
Click to expand...
total labor hours by type of maintenance work by class of
vehicles. I have a subtotal for each class. I want to
show percent of maintenance hours by class subtotal for
each type of maintenance work.
 
-----Original Message-----
My report shows percent of maintenance hours of grand
total labor hours by type of maintenance work by class of
vehicles. I have a subtotal for each class. I want to
show percent of maintenance hours by class subtotal for
each type of maintenance work.
Click to expand...


Well, I still don't know how you're getting a subtotal, but
if you're using an aggregate function (Count, Sum, etc) put
it in a text box in the group header section so it is
available for use in the detail section.
 
Back
Top