Counting a yes/no field

[Guest]

OK I'm brain dead on this Friday. I want the query to count the number of
yes entries in three field, independantly. Right now I get (for two records)
2 in each field even though I have 2 entries in field one, 1 in field two and
0 in field three.

Desired results:

EX. a count of entries
field 1 10
field 2 3
field 3 5

SELECT [IntraDay Mgmt - Table].Contact, Count([IntraDay Mgmt - Table].Email)
AS CountOfEmail, Count([IntraDay Mgmt - Table].Pager) AS CountOfPager,
Count([IntraDay Mgmt - Table].Phone) AS CountOfPhone
FROM [IntraDay Mgmt - Table]
WHERE ((([IntraDay Mgmt - Table].Date) Between [Enter Starting Date] And
[Enter Ending Date]))
GROUP BY [IntraDay Mgmt - Table].Contact;

 

[Duane Hookom]

Count() will count yes and no exactly the same. You probably need to use an
expression like:

SELECT Sum(Abs(YourField)) as NumYourFieldYes, ...
FROM tblYourTable
GROUP BY...;

 

[Guest]

Great, that's it

Count() will count yes and no exactly the same. You probably need to use an
expression like:

SELECT Sum(Abs(YourField)) as NumYourFieldYes, ...
FROM tblYourTable
GROUP BY...;

--
Duane Hookom
MS Access MVP

OK I'm brain dead on this Friday. I want the query to count the number of
yes entries in three field, independantly. Right now I get (for two
records)
2 in each field even though I have 2 entries in field one, 1 in field two
and
0 in field three.

Desired results:

EX. a count of entries
field 1 10
field 2 3
field 3 5

SELECT [IntraDay Mgmt - Table].Contact, Count([IntraDay Mgmt -
Table].Email)
AS CountOfEmail, Count([IntraDay Mgmt - Table].Pager) AS CountOfPager,
Count([IntraDay Mgmt - Table].Phone) AS CountOfPhone
FROM [IntraDay Mgmt - Table]
WHERE ((([IntraDay Mgmt - Table].Date) Between [Enter Starting Date] And
[Enter Ending Date]))
GROUP BY [IntraDay Mgmt - Table].Contact;