Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 502
  • Last Modified:

How do you put a criteria to say 1thru10 in a IIF statement

I have a number field called Production. I have alot of production numbers.


I thought this code was working but I noticed that all the production numbers are
using the false code. Is there any way I can say 1thru10(example) in the code instead of typing in all the numbers. I know it is a little over one thousand chracters can be used.

Is this even possible? I tried using Between AND but I kept getting a error message that (operater missing)

, IIf([Production]=343-346 Or [Production]=347-374 Or [Production]=379-380 Or [Production]=391-403 Or [Production]=405-407 Or [Production]=409-410 Or [Production]=412-422 Or [Production]=424-428 Or [Production]=432-464 Or [Production]=467 Or [Production]=471-507 Or [Production]=524-536,
Format(Abs(([F]![Induction]*6+[F]![TearDown]*10+[F]![Provision]*10+[F]![AssemblyA]*10+[F]![AsemblyB]*10+[F]![AssemblyC]*10+[F]![AssemblyD]*10+
[OutDuction]*10)/100),"00.0%")) AS Percentages
FROM tblTempleFacilityFullup AS F;
0
gigifarrow
Asked:
gigifarrow
1 Solution
 
Rey Obrero (Capricorn1)Commented:
yes you can use between, here is the format

 IIf([Production] Between 343 and 346 Or [Production] Between 347 and 374 Or ..
0
 
gigifarrowAuthor Commented:
Thank you,

 that works I was using [Production] = Between 347 and 374 thats why mind wasnt working
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now