Solved

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

Posted on 2013-06-21
2
472 Views
Last Modified: 2013-06-21
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
Comment
Question by:gigifarrow
2 Comments
 
LVL 120

Accepted Solution

by:
Rey Obrero (Capricorn1) earned 500 total points
ID: 39267001
yes you can use between, here is the format

 IIf([Production] Between 343 and 346 Or [Production] Between 347 and 374 Or ..
0
 

Author Comment

by:gigifarrow
ID: 39267035
Thank you,

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

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
As tax season makes its return, so does the increase in cyber crime and tax refund phishing that comes with it
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

820 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question