How do I sum fields in a report? 2

[mrtauntaun]

If I try to do it in the query, I get a circular error. I have a bunch of fields in a report, and I would like to have the report display a sum. Can this be done within the report? IF not, how can I avoid the error in the query?

 

[67peshawar294]

In in an unbound textbox in the report footer type
=sum([field1])+sum([field2}+sum([field3]
for as many fields as you like.
It can also be done in a query by selecting a blank QBE grid and in the field line place a name followed by a colon and the computation;
TOTALS:[field1]+[field2]+[field3]

jim

 

[mrtauntaun]

There is only one field, but it appears multiple times for every entry with a specified date. Effectively, there is only Field1. Can I still do this?

 

[PaulBricker]

=Sum([field1]) should do it. You have to do the calculation in a group footer or the Report Footer. The Page footer won't return a value for you.

Paul