Calculation In a Report

[JCMcAbee]

Hello. Access 2003. I hope this makes sense. I request assistance with the following calculation problem:

In a grouped(?) footer of the report I have the following calculations in text boxes, and they are working well:

Column1: =Sum([pays])
Column2: =Sum([fuel])
Column3: =Sum([osa])
Column4: =(Count([fit(i)])+Count([ag(i)])+Count([azg(i)])-Count([loc_id]))/4
Column5: =Sum([pays])+Sum([fuel])+Sum([osa])+(Count([fit(i)])+Count([ag(i)])+Count([azg(i)])-Count([loc_id]))/4

Column5 is the grand total of columns 1-4

In the report footer I have the following calculations going on, and they are working well:

Column1: =Sum(Abs([main Zone]=1)*([pays]))
Column2: =Sum(Abs([main Zone]=1)*([fuel]))
Column3: =Sum(Abs([main Zone]=1)*([osa]))
Column4: (blank)
Column5 (blank)

My problem is this: I would like Columns 4&5 of the grouped area to carry to Columns 4&5 of the report footer. I can get Columns 1-3 to carry to the report footer, but not Columns 4&5. Again, Column5 being the grand total for that zone.

Thanks in advance.

[MMcCarthy]

Have you tried just copying 4 and 5 as they stand to the report footer.