Solved
Total for check marks add to 100 but not getting 100%
Posted on 2012-12-27
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%")