Getting a total for yes/no fields

#1

I can use the sum function in a query to get the total number of "yes"
entries in a table, but I finish up with a negative number. I've tried
working with the ABS function in an expression, without success.
Is there an easy answer, please?

#2

This query will do what you seek:

SELECT Abs(Sum(YesNoFieldName)) AS YesCount
FROM TableName;

--

Ken Snell
<MS ACCESS MVP>

"Paul Danaher" <paul.danaher (AT) watwinc (DOT) com> wrote

Quote:

I can use the sum function in a query to get the total number of "yes"
entries in a table, but I finish up with a negative number. I've tried
working with the ABS function in an expression, without success.
Is there an easy answer, please?

#3

Ken Snell wrote:

Quote:

This query will do what you seek:

SELECT Abs(Sum(YesNoFieldName)) AS YesCount
FROM TableName;

Thanks, that works. And the moral is - learn SQL.

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Getting a total for yes/no fields

comp.database.ms-access comp.database.ms-access

Getting a total for yes/no fields - 06-13-2007 , 01:39 PM

Re: Getting a total for yes/no fields - 06-15-2007 , 10:30 PM

Re: Getting a total for yes/no fields - 06-16-2007 , 09:33 AM