Report SubTotals

[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.

 

[Marshall Barton]

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.

What subtotal value?

 

[Guest]

-----Original Message-----

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.

What subtotal value?
--
Marsh
MVP [MS Access]
.
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.

 

[Marshall Barton]

-----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.

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.