N
NewPCConsultant
I have inherited a database that calculates percentages based on whether a
checkbox = true or false. The problem that I am having is that I have been
tasked to change the values for certain boxes, and now when I go to calculate
the totals, some of the totals are showing a 1 meaning 100% and others are
showing a .8 or 80% when all boxes are checked. Here is the sql for the
query. Can someone please help?
AssembScore:
([tblAssembly]![AssmCor]*-20+[tblAssembly]![AssmJkt]*-10+[tblAssembly]![AssmAppC]*-10+[tblAssembly]![AssmSig]*-20+[tblAssembly]![AssmCorAmt]*-10+[tblAssembly]![AssmCorSex]*-10+[tblAssembly]![AssmDOB]*-5+[tblAssembly]![AssmAddCor]*-10+[tblAssembly]![AssmPremCor]*-5)/100
Thanks in advance
checkbox = true or false. The problem that I am having is that I have been
tasked to change the values for certain boxes, and now when I go to calculate
the totals, some of the totals are showing a 1 meaning 100% and others are
showing a .8 or 80% when all boxes are checked. Here is the sql for the
query. Can someone please help?
AssembScore:
([tblAssembly]![AssmCor]*-20+[tblAssembly]![AssmJkt]*-10+[tblAssembly]![AssmAppC]*-10+[tblAssembly]![AssmSig]*-20+[tblAssembly]![AssmCorAmt]*-10+[tblAssembly]![AssmCorSex]*-10+[tblAssembly]![AssmDOB]*-5+[tblAssembly]![AssmAddCor]*-10+[tblAssembly]![AssmPremCor]*-5)/100
Thanks in advance