G
Guest
Hello,
I'm trying to count or sum the field called "RESULTS" depending on the value
(e.g. PASS, FAIL, N/A). I've used the "count" function and it did not work.
I now use the "sum" function and it returns the correct value but puts the
minus in front of the value (e.g. -17, -30 etc.,). Thank you for your help.
Control Source
=Sum(qryTestsOut.RESULTS="PASS")
returns value -20
I'm trying to count or sum the field called "RESULTS" depending on the value
(e.g. PASS, FAIL, N/A). I've used the "count" function and it did not work.
I now use the "sum" function and it returns the correct value but puts the
minus in front of the value (e.g. -17, -30 etc.,). Thank you for your help.
Control Source
=Sum(qryTestsOut.RESULTS="PASS")
returns value -20