Sum of Fields

[linjoye]

I have a form with Amount1, Amount2, Amount3, Amount4 and TotalAmount. When I have all amount fields populated, Total/Amount field works. When amount fields are not all populated, Total/Amount shows nothing. Any suggestions?

[ConneXionLost]

Hi linjoye,

Use the Nz function.

In your case:

TotalAmount:  Nz([Amount1])+Nz([Amount2])+Nz([Amount3])+Nz([Amount4])

Cheers,

[linjoye]

It worked.

Many thanks!