Format Issue

[jbailey4545]

Having trouble with the following:

OxygenDevice: IIf([oxygen_related]=2,"TEST",IIf([oxygen_related]=1,"Mask","0"))

If oxygen_related=2 it is still showing as 0

I checked the table and oxygen_related is set to Number and can't get it to work correctly.

[JoeM]

What number format is the field? Is it Integer or Byte?
If it is something that allows decimals, you may have a floating arithmetic/rounding issue going on, and you may need to round the value first before checking it.
Here is a link on the "floating arithmetic" situation: http://support.microsoft.com/kb/78113
and the workaround (discussed from Excel standpoint, but concept is the same for Access): http://support.microsoft.com/kb/214118