Formula Error

[gail2767]

First, I didn't name these fields, but I have to work with them. Second, this formula isn't working for me. I'm not sure why. The fields are number fields, and what I want is if the field is less than one, I want it to show the field that has the total number of unit numbers. I would appreciate any help you could give me.

Thanks in advance, Gail


Control Source....=IIf([Units Number (per type)g]=0,[Total Number of Units],[Units Number (per type)g])

Format....#,##0;-#,##0;#

 

[PaulF]

is the default value zero? if not then you might need to use the NZ function

=IIf(Nz([Units Number (per type)g],0)=0,[Total Number of Units],[Units Number (per type)g])

PaulF

 

[gail2767]

That didn't work either. I'm not sure what is going on, I've used this type of formula many times without a problem. But thank you so much for your input.

 

[PaulF]

are you receiving an error message, or just incorrect data?

PaulF