gigifarrow
asked on
Using Multiple criteria for iif Statemants
This criteria is based on the production number so far if it is >=73 or if it is <=4 it uses the first code but all else uses the second code. The problem I have is that I have over 300 production number that need the first code. but in the 300 some do not so Im having to go aaround and pick and choose numbers.
How do I put like for example 300-400 as a criteria and then drop down to 200-250 with out having to name each production number individually? This is what Im tring to do.
IIf([Production]>=73 Or [Production]<=4 or [Production]=300-322 or [Production]= 400-422
and on with out having to name each number invidually instead of sayin 400 , 401, 402 etc.
This code works fine but i need to add more criteria
IIf([Production]>=73 Or [Production]<=4,
(Abs(([F]![Induction]*4+[F ]![Defuel] *1+[F]![Tu rretPull]* 3+[F]![Fue lCellRemov ed]*5+[F]! [BFCSProvi sion]*3+[F ]![Err]*10 +[F]![TASS ]*16+[F]![ BASSDProvi sion]*8+[F ]![BASSDIn stalled]*1 4+[F]![BFC SInstalled ]*10+[F]![ TurretInst alled]*4+[ F]![E1Grou nd]*1+[F]! [DriverSea tSpacer]*1 +[F]![Gunn ersSeatSto p]*1+[F]![ AFESSwitch Guard]*1+[ F]![Relief HoleExting uisher]*1+ [F]![25mmH otBox]*2+[ F]![ErrHan dleMod]*0+ [F]![FuelS hutoffSlee ve]*1+[F]! [FinalQAQC ]*8+[F]![O utduction] *6)/100)*1 00),
(Abs(([F]![Induction]*5+[F ]![Defuel] *1+[F]![Tu rretPull]* 10+[F]![Fu elCellRemo ved]*10+[F ]![BFCSPro vision]*5+ [F]![Err]* 10+[F]![TA SS]*10+[F] ![BASSDPro vision]*0+ [F]![BASSD Installed] *0+[F]![BF CSInstalle d]*10+[F]! [TurretIns talled]*10 +[F]![E1Gr ound]*1+[F ]![DriverS eatSpacer] *0+[F]![Gu nnersSeatS top]*1+[F] ![AFESSwit chGuard]*1 +[F]![Reli efHoleExti nguisher]* 1+[F ]![25mmHotBox]*2+[F]![ErrH andleMod]* 0+[F]![Fue lShutoffSl eeve]*1+[F ]![FinalQA QC]*12+[F] ![Outducti on]*10)/10 0)*100)) & "%" AS Percentages
FROM tblYakimaFullup
Should I go another route?
How do I put like for example 300-400 as a criteria and then drop down to 200-250 with out having to name each production number individually? This is what Im tring to do.
IIf([Production]>=73 Or [Production]<=4 or [Production]=300-322 or [Production]= 400-422
and on with out having to name each number invidually instead of sayin 400 , 401, 402 etc.
This code works fine but i need to add more criteria
IIf([Production]>=73 Or [Production]<=4,
(Abs(([F]![Induction]*4+[F
(Abs(([F]![Induction]*5+[F
FROM tblYakimaFullup
Should I go another route?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.