Tripple iif statement works only partially (1 Viewer)

MushroomKing

Registered User.
Local time
Today, 12:46
Joined
Jun 7, 2018
Messages
100
Hey guys! Again, stuff just weirds out on me and i'm at a loss for something very simple...:banghead::D

So I have a query with this statement:

problem: IIf([difference]>=0;"Short";IIf([difference]<=0;"Over";IIf([difference]=0;"Ok")))


So my results are as follows:

The "Short" seems to be used for everything, unless it's "Over"

The "Over" statement seems to work just fine. Correct results!

The "Ok" statement doesn't work at all.



Why does it partially work???? I am looking at this, trying all kinds of things, nothing works. Could you guys please put me out of my misery? Thanks!!!!!!! :eek:
 

deletedT

Guest
Local time
Today, 19:46
Joined
Feb 2, 2019
Messages
1,218
Because you have >= (greater or equal to) first.

Use it this way:
Code:
IIf([Difference]>0,"Short",IIf([Difference]<0,"Over",IIf([Difference]=0,"Ok")))
 
Last edited:

MushroomKing

Registered User.
Local time
Today, 12:46
Joined
Jun 7, 2018
Messages
100
Dammit...I should find another job...

Thank you very much! :)
 

CJ_London

Super Moderator
Staff member
Local time
Today, 19:46
Joined
Feb 19, 2013
Messages
16,553
or just

IIf([Difference]>0,"Short",IIf([Difference]<0,"Over","Ok"))
 

Users who are viewing this thread

Top Bottom