Undefined function iff in expression

[MushroomKing]

Hey guys! Could someone help me maybe? I have no idea what im not getting.
I used this type of expression/statement before, but now i dont understand.


I made a new field with the following code in the field name:

buildsize: iff([volume_m3]<0,"smaller")

But i get an undefined function iff in expression.

Thanks in advance people!

 

[isladogs]

The function is IIf and it has three parts
Iif(some condition, result if true, result if false)

So you need something like

buildsize: IIf([volume_m3]<0,"smaller","same or bigger")

 

[MushroomKing]

Thanks ISLA

That did it. I should have know also...

Just one more, where i calculate, but i get the same error.
Again i dont see this one either :S

checkorder: iff([cocota]<[rusty],"Total too high","Total too low")

 

[plog]

Iif will work with just 2 parameters:

buildsize: iif([volume_m3]<0,"smaller")

What you did is type Iff (with 2 f's) and not Iif (with 2 I's), thus the undefined function.

 

[MushroomKing]

Damn...i feel ashamed.

Kinda need to get used to the fact that its double anyway. Coming from PHP background


Thanks! would not have found out because its so silly

 

[isladogs]

As plog rightly says IIf will work without a false clause and defaults to an empty string for text.
However if you try doing that with a numerical comparison such as IIf(3>4,1), Access throws a compile error
Similarly comparing two dates without a false clause.

Of course, Iff that you wrote again will never work

BTW my spell checker automatically replaces 'plog' with plot. So if I ever reply with that I haven't lost the plot (probably...)

 

[plog]

I don't get a compile error for:

Test: IIf(3>4,1)

Nor for this:

Test2: IIf(Date()>Date(),1)

 

[isladogs]

I tested both in the immediate window. For example as attached screenshot

 

[plog]

I did mine in a query and worked fine.

 

[isladogs]

Interesting. I've just repeated both tests using a query and as you say, both work.
I suspect behind the scenes, the query optimizer is adding a null false value in each case.
Either way, I prefer to add a false value so I have 'control' over the output