Sum a Row with 5 fields

H

Haole

I have a single table with 5 fields containing numerical data between 0 and
3. I would like to sum the 5 fields. For example, field one has a data
value of 1, field two has a data value of 2, field three has a data value of
3, field four has a data value of 0, field five has a data value of 2.

This should sum to: 8

Any help on this query would be great.
 
K

KARL DEWEY

Row Sum: [Field1] + [Field2] +[Field3] + [Field4] + [Field4]
That is unless you have nulls.
 
L

Lord Kelvan

rowtotal: myfield1+myfield2+myfield3+myfield4+myfield5

in the query builder put that in a field box or you can use the sql

select myfield1+myfield2+myfield3+myfield4+myfield5 as row total
from mytable

hope this helps

Regards
Kelvan
 
J

Jeff Boyce

That sounds like a spreadsheet.

Is there a reason you aren't doing this in Excel?

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Top