Not able to calculate total when one field box is blank????

[Alphix]

time calculatorREV3.zip

Hello, I have tried to calculate the total in field box D when A, B has data and C has not data.

In short how do I calculate when one data box is empty?




Please help.

[pbaldy]

Sounds like you need the Nz() function:

Nz(Field1, 0) + Nz(Field2, 0)

[Alphix]

Thanks, that did the trick.

I have much to learn.

[pbaldy]

Happy to help!