Iif function

[Bertrand82]

Hi gyys,



I normally have success with iif functins but has met a strange behaviour.

I have a lot of blank values in field2. Would like a new field with the blank values returned as zeros instead.

I cant get this to work....

Newfieldwithzeros: IIf([Field2]="";0;1)

is this correct?

br betrand

[qa12dx]

how i'd do it is, change the default value of the field to 0. then run a update query to make the nulls to zero.

afterthat your queries should work fine

[Bertrand82]

It worked! thanks.