need help with failing Iif function

[wilkob]

In my query I have the folowing expression:

Currency: Iif([Exch]="1";"Szt";"Eur") - if the exchange rate is 1 then the currency is Zlotty if different from 1 then it's Euro

When I run the query it returns "#Error" ?

Anyone have an idea to fix this?

 

[Rickster57]

query

myexpression:Iif([Exch]="1","Szt","Eur")

Assuming your field EXCH is a text field. If it is a number field get rid of the quotes around 1.

 

[wilkob]

Thanks !!

Removing the " " around the 1 did the trick.

And again I have learned something