Sum unbound numeric fields trouble

[swampg8r]

I have a report which has 8 unbound numeric fields at the bottom. These fields sum the unbound numeric fields above them (SHOWN AS A - H BELOW):

A...........B...........C...........D...........E...........F...........G..........H
A...........B...........C...........D...........E...........F...........G..........H
A...........B...........C...........D...........E...........F...........G..........H
A...........B...........C...........D...........E...........F...........G..........H
A...........B...........C...........D...........E...........F...........G..........H

SUM-A...SUM-B....SUM-C...SUM-D....SUM-E....SUM-F....SUM-G....SUM-H

The above sums return values.

Now I'm trying to add the SUM-A thru SUM-H fields. I have defined a text box as a numeric field (general number with 0 decimal) with a control source defined:
=[SUM-A]+[SUM-B]+[SUM-C]+[SUM-D]....+[SUM-H].

But it is not returning a value. I'm stuck and not sure what else I can try. I've tried using Val[SUM-A]+Val[SUM-B]...I've tried =SUM.

Any advice would be much appreciated.

Thanks, Kris

 

[sfreeman@co.mer]

GrandTotal ControlSource should look like:

=([Text25]+[Text27]+[Text29]+[Text29]+[Text31]+[Text33]+[Text35])

Each of these fields represents the total for each column.

Works on my test.

HTH