• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 505
  • 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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Microsoft Office 2010

This course will introduce you to the interfaces and features of Microsoft Office 2010 Word, Excel, PowerPoint, Outlook, and Access. You will learn about the features that are shared between all products in the Office suite, as well as the new features that are product specific.

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