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].IsSpanishSpeaking, [Anonymous Callers].[County Code ID2],
[Anonymous Callers].Date, Sum([Anonymous Callers].IsSpanishSpeaking)
AS SumOfIsSpanishSpeaking, Count([Anonymous Callers].[County Code
ID2]) AS [CountOfCounty Code ID2]
FROM [Anonymous Callers]
GROUP BY [Anonymous Callers].CallerID, [Anonymous
Callers].IsSpanishSpeaking, [Anonymous Callers].[County Code ID2],
[Anonymous Callers].Date;

Thanks for any ideas,

Zuf

[zufie]

On May 7, 2:32*pm, zufie <[e-mail]:

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].IsSpanishSpeaking, [Anonymous Callers].[County Code ID2],
[Anonymous Callers].Date, Sum([Anonymous Callers].IsSpanishSpeaking)
AS SumOfIsSpanishSpeaking, Count([Anonymous Callers].[County Code
ID2]) AS [CountOfCounty Code ID2]
FROM [Anonymous Callers]
GROUP BY [Anonymous Callers].CallerID, [Anonymous
Callers].IsSpanishSpeaking, [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].IsSpanishSpeaking, [Anonymous Callers].[County Code ID2],
[Anonymous Callers].Date, Sum(-([IsSpanishSpeaking])) AS Expr1,
Count([Anonymous Callers].[County Code ID2]) AS [CountOfCounty Code
ID2]
FROM [Anonymous Callers]
GROUP BY [Anonymous Callers].CallerID, [Anonymous
Callers].IsSpanishSpeaking, [Anonymous Callers].[County Code ID2],
[Anonymous Callers].Date;
I added the expression: Expr1: Sum(-([IsSpanishSpeaking]))

to my above query

Thanks,

Zufie