troubleshooting Question

Reduced Query that was over 1000 characters and still over What is another alternative?

Avatar of gigifarrow
gigifarrow asked on
Microsoft AccessSQL
15 Comments1 Solution411 ViewsLast Modified:
first I like to thank all the experts that have got me this far.  I reduced the characters and I am still over!

Below  are three IIf statements. Based on what the Production number is these fields that are check marks equal certain amounts once they have been checked.

All this code is calculated  in a field called Percentages.

If I am not able to use it in a query how would I do the other alternative?

,IIf([Production] Between 1 And 132 Or [Production] Between 134 And 136 Or [Production] Between 140 And 146 Or [Production]= 151 Or 152 Or [Production] Between 158 And 164 Or [Production] Between 167 And 237,Format(Abs((Induction*5+Defuel*1+TurretPull*3+FuelCellRemoved*5+BFCSProvision*11+ERR*10+TASS*10+BASSDProvision*11+BASSDInstalled*11+BFCSInstalled*10+TurretInstalled*5+[E1Ground]*1+[DriverSeatSpacer]*1+GunnersSeatStop*1+AFESSwitchGuard*1+ReliefHoleExtinguisher*1+[25mmHotBox]*2+ACS*1+FuelShutoffSleeve*1+FinalQAQC*5+Outduction*4)/100),"00.0%"),IIf([Production]= 133 Or [Production] Between 137 And 139 Or [Production] Between 147 And 150 Or [Production] Between 153 And 157 Or [Production]= 165 And 166,Format(Abs((Induction*5+Defuel*1+TurretPull*3+FuelCellRemoved*5+BFCSProvision*3+ERR*10+TASS*16+BASSDProvision*8+BASSDInstalled*14+BFCSInstalled*10+TurretInstalled*4+E1Ground*1+DriverSeatSpacer*1+GunnersSeatStop*1+AFESSwitchGuard*1+ReliefHoleExtinguisher*1+[25mmHotBox]*2+ACS*1+FuelShutoffSleeve*1+FinalQAQC*8+Outduction*5)/100),"00.0%"),IIf([Production] Between 218 And 220 Or [Production] Between 234 And 300,Format(Abs((Induction*4+Defuel*1+TurretPull*3+FuelCellRemoved*5+BFCSProvision*3+ERR*10+TASS*13+BASSDProvision*8+BASSDInstalled*14+BFCSInstalled*10+TurretInstalled*4+E1Ground*1+DriverSeatSpacer*1+GunnersSeatStop*1+AFESSwitchGuard*1+ReliefHoleExtinguisher*1+[25mmHotBox]*2+ACS*1+FuelShutoffSleeve*1+FeriteBead*3+FinalQAQC*8+Outduction*5)/100),"00.0%")))) AS Percentages
FROM tblFortCarsonFullup AS F;

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 15 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 15 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros