Trouble with Sums

[ZeoGel]

I have 2 questions
1. I have a record with 3 choices on one column meaning you can choose a , b or c. Now i need to sum each one of the choices can someone help?

2. I have a check box and i want to sum up everytime it has been checked i keep coming up with a negative number how can i make it positive

Thank you
Ron

 

[cmmrfrds]

True in Access is -1. Probably need to strip off the sign before summing. One way is sum(ABS(yourcheckfield)) or any other way that removes the sign.


Use the ternary function iif to put a 1 or 0 depending on the value and sum all the 1's.

select sum(iif(fld='a',1,0) as choicesA, sum(iif(fld='b',1,0) as choicesB, sum(iif(fld='c',1,0) as choicesC
from yourtable.

 

[ZeoGel]

Thank You Cmmrfrds It worked great