Counting

[zufie]

When I try to count the number of checkboxes containing a check inside
I receive a negative number (-1) for each checked checkbox. This is in
a query.

What can I do to change my query so that a (-1) does not return as
counting one checked checkbox.

Here is my code:

SELECT [Anonymous Callers].CallerID, [Anonymous
Callers].IsSpanishSpeak ing, [Anonymous Callers].[County Code ID2],
[Anonymous Callers].Date, Sum([Anonymous Callers].IsSpanishSpeak ing)
AS SumOfIsSpanishS peaking, Count([Anonymous Callers].[County Code
ID2]) AS [CountOfCounty Code ID2]
FROM [Anonymous Callers]
GROUP BY [Anonymous Callers].CallerID, [Anonymous
Callers].IsSpanishSpeak ing, [Anonymous Callers].[County Code ID2],
[Anonymous Callers].Date;

Thanks for any ideas,

Zuf

[zufie]

Re: Counting

On May 7, 2:32 pm, zufie <john.marru...@ illinois.govwro te:

When I try to count the number of checkboxes containing a check inside
I receive a negative number (-1) for each checked checkbox. This is in
a query.
>
What can I do to change my query so that a (-1) does not return as
counting one checked checkbox.
>
Here is my code:
>
SELECT [Anonymous Callers].CallerID, [Anonymous
Callers].IsSpanishSpeak ing, [Anonymous Callers].[County Code ID2],
[Anonymous Callers].Date, Sum([Anonymous Callers].IsSpanishSpeak ing)
AS SumOfIsSpanishS peaking, Count([Anonymous Callers].[County Code
ID2]) AS [CountOfCounty Code ID2]
FROM [Anonymous Callers]
GROUP BY [Anonymous Callers].CallerID, [Anonymous
Callers].IsSpanishSpeak ing, [Anonymous Callers].[County Code ID2],
[Anonymous Callers].Date;
>
Thanks for any ideas,
>
Zuf

Got it...

Here is my revised code:

SELECT [Anonymous Callers].CallerID, [Anonymous
Callers].IsSpanishSpeak ing, [Anonymous Callers].[County Code ID2],
[Anonymous Callers].Date, Sum(-([IsSpanishSpeaki ng])) AS Expr1,
Count([Anonymous Callers].[County Code ID2]) AS [CountOfCounty Code
ID2]
FROM [Anonymous Callers]
GROUP BY [Anonymous Callers].CallerID, [Anonymous
Callers].IsSpanishSpeak ing, [Anonymous Callers].[County Code ID2],
[Anonymous Callers].Date;


I added the expression: Expr1: Sum(-([IsSpanishSpeaki ng]))

to my above query

Thanks,

Zufie