Sum of a Check Box

[Guest]

Hi all, I have a check box in my form that I want to total up. It is Lives
Saved. What I want is a simple total.

This is what I have:
SELECT tblSENESarLog.FY, Sum(tblSENESarLog.LIVESSAVED) AS SumOfLIVESSAVED,
tblSENESarLog.LIVESSAVED
FROM tblSENESarLog
GROUP BY tblSENESarLog.FY, tblSENESarLog.LIVESSAVED
HAVING (((tblSENESarLog.LIVESSAVED)=Yes))
ORDER BY tblSENESarLog.FY DESC;

What am I doing wrong?

Thanks!

 

[Guest]

What you are doing wrong is not tell us what's wrong about your results. It
looks like you might be getting a negative number rather than positive. This
could be solved by using the Abs() function.

 

[Guest]

"What you are doing wrong is not tell us what's wrong about your results"

Ok, that mau be one thing, but what I am getting is a list like FY, the
count, then a number but they are in 3 columns. What I want is just a total
of all times the box has been checked, for a total amount of lives saved.

Thanks

 

[Guest]

Try:
SELECT Sum(Abs(LIVESSAVED)) AS SumOfLIVESSAVED
FROM tblSENESarLog;