Solved

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

Posted on 2013-06-21
2
456 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 119

Accepted Solution

by:
Rey Obrero 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

[Webinar] Disaster Recovery and Cloud Management

Learn from Unigma and CloudBerry industry veterans which providers are best for certain use cases and how to lower cloud costs, how to grow your Managed Services practice in IaaS clouds, and how to utilize public cloud for Disaster Recovery

Question has a verified solution.

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

A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.

910 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

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now