Calculations in a query or report.

[scottbob]

What I am trying to is is create a field in a query or table that will
add up to 25 other fields. Then later used to calculate another number
in report. Creating a calculation box in the report is not a problem;
the problem is when I try to total up 18 other fields in that same
report to be used to get another calculated value. I have tried doing
this in the report and ran into 2 problems. One is that the box in the
report won't seem to add up more than 12 items. The other is that since
that is not an actual field in the table/query it can't be used to
automatically calculate other values. If anyone has any ideas i would
greatly appreciate any advice. Thanks.

 

[Guest]

Have you tried to do the calculating in your query?

Totals: Nz([Field1],0)+Nz([Field2],0)+Nz([Field3],0)+ ... Nz([Field18],0)

The Nz function allows summing fields that may be null.