iif Function not giving me correct results

[Ramesh Kumar C]

Hi Folks,



I tried running the Iif Function in access and it is not giving me expected results. Please check the below query I have used.

IIf([ENTRY AMT]<0,"Negative","Positive")

Please help me to get correct results...

Thanks

[pbaldy]

What is it doing wrong? Is the field text rather than numeric?

[Ramesh Kumar C]

It is populating "#Error" value instead of "Negative" or "Positive".

The data type of the filed is Short Text.

[Ramesh Kumar C]

Hi Paul,

I have changed the data type to "Number". And i have got the expected values. Thanks a lot.

Ramesh

[pbaldy]

No problem.