How do i sum fields in a record?

[Guest]

Hi, I have a database created in Office 2003 in which I need to total
amounts in various fields within a record. I cant seem to get it to work.
Can anyone help?

Thanks

 

[Rick B]

Just add an unbound control in your forms or reports such as:

=[Field1]+[Field2]+[Field3]...

To do so in a query, add anew column such as...

NewFieldName: [Field1]+[Field2]+[Field3]...

 

[John Vinson]

Hi, I have a database created in Office 2003 in which I need to total
amounts in various fields within a record. I cant seem to get it to work.
Can anyone help?

Thanks

As suggested, a calculated field in a Query like

SumOfFields: [Field1] + [Field2] + [Field3]

is a start. Note that this sum cannot be calculated (and should not be
stored) in a Table; use a dynamic calculation in a query instead.

If any of the fields might be NULL, you'll get NULL as the sum. To
solve this use

SumOfFields: NZ([Field1]) + NZ([Field2]) + NZ([Field3])

instead of the simpler expression - the NZ (Null To Zero) function
will convert null (unknown, undefined) values to 0.

John W. Vinson[MVP]

 

[Guest]

Thanks, I'll give that a try

Hi, I have a database created in Office 2003 in which I need to total
amounts in various fields within a record. I cant seem to get it to work.
Can anyone help?

Thanks

As suggested, a calculated field in a Query like

SumOfFields: [Field1] + [Field2] + [Field3]

is a start. Note that this sum cannot be calculated (and should not be
stored) in a Table; use a dynamic calculation in a query instead.

If any of the fields might be NULL, you'll get NULL as the sum. To
solve this use

SumOfFields: NZ([Field1]) + NZ([Field2]) + NZ([Field3])

instead of the simpler expression - the NZ (Null To Zero) function
will convert null (unknown, undefined) values to 0.

John W. Vinson[MVP]

 

[Guest]

Thanks for your help

Just add an unbound control in your forms or reports such as:

=[Field1]+[Field2]+[Field3]...

To do so in a query, add anew column such as...

NewFieldName: [Field1]+[Field2]+[Field3]...


--
Rick B

Hi, I have a database created in Office 2003 in which I need to total
amounts in various fields within a record. I cant seem to get it to work.
Can anyone help?

Thanks