Sum of a Check Box

  • Thread starter Thread starter Guest
  • Start date Start date
G

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!
 
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.
 
"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
 
Back
Top