Expression Builder: If And Or

mtagliaferri

Registered User.
Local time
Today, 05:07
Joined
Jul 16, 2006
Messages
550
I have an old expression which works fine:
Code:
=IIf([DutyType]='O' Or [BobNewNear]=0,0,IIf([BobNewNear]<6,6,[BobNewNear]))

I am now in a situation that I have to add a new [DutyType] so now I have also H to add as of a duty Type, therefore if Duty Type is O or H has to return 0, anything up to 6 return 6 otherwise returns BobNewNear.

Where do I add the H condition?
 
just add it to your expression:

=IIf([DutyType]='O' Or [DutyType]='H' Or [BobNewNear]=0,0,IIf([BobNewNear]<6,6,[BobNewNear]))
 
If DutyType='R' and BobNewYear=0 you want it to return 0?
 

Users who are viewing this thread

Back
Top Bottom