Report Footer Calculation

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

 

[Remou]

Is this

http://support.microsoft.com/kb/207763

the problem?

forum703 is the dedicated forum for reports.

 

[JCMcAbee]

It might be similar, but my inexperience is telling me not quite. I will repost in the reports forum. Thanks