Vanishing values

  • Thread starter Thread starter Richard Jones via AccessMonster.com
  • Start date Start date
R

Richard Jones via AccessMonster.com

Hi, I have an equation =a+b that is not giving a value if the source for a does not have a value for that record. How do I make sure that 'a' either returns its value or 0 if it doesn't have one. It calculates ok as it appears briefly on the screen but then disappears!

Hope this makes sense. Thanks for any help in advance.
RJ
 
Or even simpler.

equation = Nz(a, 0) + Nz(b, 0)

Ron W
Dave Bradshaw said:
equation = If(IsNull(a), 0, a) + b
Click to expand...
a does not have a value for that record. How do I make sure that 'a' either
returns its value or 0 if it doesn't have one. It calculates ok as it
appears briefly on the screen but then disappears!
 
There, you learn something new everyday. I had never seen the Nz
function before. Thanks Ron
 
Back
Top