multiple calculations in footer

[aussie_user]

Hi,

I'm am trying to figure out how to do calculations for fields in a report. I've managed to get my report to show

Consultant

Project GrantAmount ConsultantFee

Data Data Data
Data Data Data

------------------------------------------------------------------
Total for Consultant
="Total for " & [Consultant] & ":" =Sum([GrantAmount]) =Sum([ConsultantFee])

My problem is the Sum for Grant Amount works and provides the appropriate total but the Sum of the Consultant Fee does not provide a total. Is there a limit to one sum per footer? I was also thinking of adding another field to calculate the percentage but want to make sure I get the Consultant Fee Total working first.

Thanks

 

[Brian900]

Did you check the format of the textbox? I have a report with 70 or so sums, counts and percentages in the footer. I think access might limit you to 255 controls. I'm really unsure about that. Anyone else know?

Brian.

 

[aussie_user]

Thanks for you reply.

I don't think it is the amount of controls as there are less than 20 on the entire report. As for format, I copied the control that worked and just changed the syntax from GrantAmount to ConsultantFee so the format should be the same.

 

[Stew]

Just a quick suggestion which might do the trick. Try playing with the syntax, maybe another "&" between the calculations and/or getting rid of the extra "=":

Total for Consultant
="Total for " & [Consultant] & ":" Sum([GrantAmount]) & " " & Sum([ConsultantFee])


Paul

 

[Stew]

Oops, may need another "&"

="Total for " & [Consultant] & ":" & Sum([GrantAmount]) & " " & Sum([ConsultantFee])