Adding 2 Fields together..returns error if no value

[jhjarvie]

This is Driving me crazy, I am trying to add the value of 2 Fields together in a seperate field on a form, everything works fine and I get a total no problem...until one of the two fields I am adding has no value in it, then I get #Error!
Sometimes there will be no value in one or both of the fields I cant avoid that.


Any help??

[RuralGuy]

Have you tried using the Nz() function?

[jhjarvie]

Have you tried using the Nz() function?

Wow, I Completely missed that one! thanks RuralGuy it's now working

[RuralGuy]

That's great! I guess you are ready to use the Solved thread tool now, right?

[jhjarvie]

Will do........