Adding multiple fields in a single record in access 2k

[MorelandPI]

Is there a specific expression formula I can use to add multiple
fields in a single record (within a form) to sum it to a field.
Currently I tried =Sum([Field1]+[Field2]+[Field3]). This is adding
all the numbers in all the fields in all records withing that form.
Sorry not exactly a pro to this but any help would be appreciated.

Phill

 

[Allen Browne]

Drop the Sum() part, i.e.:
=[Field1] + [Field2] + [Field3]

If any field is Null, the result will be Null, so you probably want:
=Nz([Field1],0) + Nz([Field2],0) + Nz([Field3],0)

If you have several similar fields across a table, you have built a
spreadsheet, not a database. Chances are, you need to create a related table
where each value is a *record*, rather than many fields across one record in
this table.