Calculations that have null values.

[Guest]

I have 3 columns of data. Some of the fields have a null value. I would like
to add a 4th column which will be the total of the three columns.

EXPR1 EXPR2 EXPR3 Total
0 5,465 2500

I am trying to use the following
=Val(nz[expr1,0])+val(nz[expr2,0])+val(nz[expr3,0])
The error message I get is invalid syntax.
Can someone tell me what I am doing wrong?

Thanks

 

[Rick B]

=Val(nz(expr1,0))+val(nz(expr2,0))+val(nz(expr3,0))

 

[Duane Hookom]

Try:
=Val(nz([expr1],0)) + val(nz([expr2],0)) + val(nz([expr3],0))