my query returns null I need to do math on the returned value

  • Thread starter Thread starter rich L
  • Start date Start date
R

rich L

I am working on yield, I have 2 qureys one for good and the other to sort the
bad in to catagorys. I want to add the total good and total bad for total
tested. Sometimes the results are null. When I add the two fields I get blank
when I should get units tested. Using access 2007 Thanks in advance.
 
I use the IIF statement, eg IIF([good]>0, [good], 0) which means that if
[good] is >0 then use the value of [good], else use the value 0.
If [good] can be negative or positive, then use:
IIF([good]>0 or [good]<0, [good], 0)
Do this for both good and bad.
 
Back
Top