Summing with a null field

[liamrowan]

I am using a formula in a report text box that sums two other fields:

A + B = C

However, if either field A or B is empty (no value at all), field C is empty as well. I'd like to be able to leave A or B empty and get a result in C.

Examples:

A (with a numerical value) + B (empty field) = A
A (empty field) + B (with a numerical value) = B
​

Also, it is possible for both A and B to be empty, in which case C should be empty as well.

Is there a way to acheive this?

Thanks for ideas.

Wm

 

[pbaldy]

Check out the Nz() function, which you would use around each value.

 

[liamrowan]

thanks, this worked well.

 

[pbaldy]

No problemo.