Sum the recod, not records!!! 1

[dkrocks]

I've got an expression on a record that sums certain fields in the records, this is all good, just what I wanted. But now it totals up the fields of all the records not each one individually. Now, which variable to I change to apply the sum expression to the individual records and not all of the records?

 

[josephwc]

Create a new field in the query.
The Field line should look like this
Field4: [Field1]+[Field2]+[Field3]+[Field4]

"Sum" should not be used at all for what you want to do.