Calculated field

[Marta]

Hi

I'm trying to set up a calculated field which counts 3 fields of my table. So I wrote to expression builder [field1] + [field2] + [field3] but when some of the fields are empty it doesn't work and I want to keep these fields empty I don't want to put there 0. Can anybody tell me how to solve this problem?

Thank you very much.

 

[John Big Booty]

Use the Nz() function to return a Zero value for values that hold null prior to calculation your total.

 

[Marta]

But I can't use Nz() function in expression builder. It is possible in a query but I don't want to make the query. I just need a table with 3 columns and one column with sums like in excel.

 

[John Big Booty]

You need something along the lines of;

Me.Total = Nz(Me.Field1, 0) + Nz(Me.Field2, 0) + Nz(Me.Field3, 0)