troubleshooting Question

Total for check marks add to 100 but not getting 100%

Avatar of gigifarrow
gigifarrow asked on
Microsoft Access
9 Comments1 Solution335 ViewsLast Modified:
Hello experts these fields are check marks everytime you click on one it is equavalent to certain percenatage
The total is 100 but I am getting 555.5% with this code that is in a query. Can somebody tell me why it doesnt equal 100% when totaled.

I tried putting all the numbers in percentage format and that didnt work either for example .02,.08.


Percentages: Format(Abs(([tblTempleFuelcellOnly]![Induction]*8+[tblTempleFuelcellOnly]![Defuel]*2+[tblTempleFuelcellOnly]![Turret ull]*5+[tblTempleFuelcellOnly]![FuelCellRemoved]*10+[tblTempleFuelcellOnly]![BFCSProvision]*2+[tblTempleFuelcellOnly]![BFCSInstall]*36+[tblTempleFuelcellOnly]![TurretInstall]*18+[tblTempleFuelcellOnly]![DriversSeatSpacer]*1+[tblTempleFuelcellOnly]![GunnersSeatStop]*1+[tblTempleFuelcellOnly]![CEPRetrofit]*2+[tblTempleFuelcellOnly]![25MM HotBox]*2+[tblTempleFuelcellOnly]![E1GroundInsert]*2+[tblTempleFuelcellOnly]![AFESCEPSwitchGuard]*1+[tblTempleFuelcellOnly]![ReliefHoleExtinguisherGuard]*1+[tblTempleFuelcellOnly]![EERHandleMod]*3+[tblTempleFuelcellOnly]![QA/QC]*2+[tblTempleFuelcellOnly]![OutDuction]*3 +[tblTempleFuelcellOnly]![Complete]*1)/18),"00.0%")
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 9 Comments.
Join the Community
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 9 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