Group Totals

[Guest]

I would like to take this report:

553011 FICA-SS/Medicare-Sourcing
(rev) 3/06 bud vs act FICA $795.00
(rev) FICA SS/MedicareSourc $1,983.00
(rev) FICA ER EXP $2,613.00
(rev) FICA Tax $2,194.00
FICA ER EXP $7,765.00

and have it grouped and sub total as so:

553011 FICA-SS/Medicare-Sourcing
(rev) 3/06 bud vs act FICA $795.00
(rev) FICA SS/MedicareSourc $1,983.00
(rev) FICA ER EXP $2,613.00
(rev) FICA Tax $2,194.00
FICA ER EXP $7,765.00

Subtotal $15350.00

 

[Marshall Barton]

I would like to take this report:

553011 FICA-SS/Medicare-Sourcing
(rev) 3/06 bud vs act FICA $795.00
(rev) FICA SS/MedicareSourc $1,983.00
(rev) FICA ER EXP $2,613.00
(rev) FICA Tax $2,194.00
FICA ER EXP $7,765.00

and have it grouped and sub total as so:

553011 FICA-SS/Medicare-Sourcing
(rev) 3/06 bud vs act FICA $795.00
(rev) FICA SS/MedicareSourc $1,983.00
(rev) FICA ER EXP $2,613.00
(rev) FICA Tax $2,194.00
FICA ER EXP $7,765.00

Subtotal $15350.00

Are those lines from a single record in the report's record
source table/query or are thsy separate records all with the
553011 code.

If the former, add a text box with an expression like:
=f1+f2+f3+f4+f5
where fx is the name of the four fields with the dollar
amounts.

If they are separate records, then use the report's Sorting
and Grouping window (View menu) to group on the code number
field. Set the group's Group Header and Footer properties
to Yes to create the sections. Put the code text box in the
group header section. Then add a text box to the group
footer section and use an expression like =Sum(amountfield)
to calculate the subtotal.