Problem with calulcation in report footer

[caz]

Hello

I am trying to calculate all the values in the group footer.

I am using the following as the fields contain nulls.


=[Nz]([basildon])+[Nz]([braintree])+[Nz]([brentwood])+[Nz]([Castle point])+[Nz]([Chelmsford])+[Nz]([colchester])+[Nz]([epping])+[Nz]([harlow])+[Nz]([maldon])+[Nz]([outside Essex])+[Nz]([rochford])+[Nz]([Tendring U & R])+[Nz]([Uttlesford])

I need to make this a sum
does anybody know the correct syntax?

Any help would be very appericated.

 

[Rich]

A quick look at your fields would indicate a design problem, post back with some details of your db, especially your table and field set up

 

[caz]

The fields come from a cross tab query and are not table fields.
The calculation work fine in the detail part of the report but will not sum in the footer as I dont know the correct syntax.

 

[Rich]

Ah yes, sorry. You could use the RunningSum property of a hidden text box

 

[caz]

Yes, I did remove the total, probably should'nt have but I did'nt think that I needed it at the time.

Would the total column in the crosstab be the total for each row?

I need the total for the whole group of rows.

would it be best for me to put back the total for each row and then use this field to calculate the grand total for the group?

 

[caz]

How does that work?