Counting Number values

[czarjosh]

I am collecting data in a field from an option box. How do I count the totals of any certain value. I am trying to use the query below, but it is giving me odd results.


SELECT [Wd] & " - " & [PR] AS Precinct, Count(ContactTimes.ContactData) AS CountOfContactData
FROM [DF Voter File] INNER JOIN ContactTimes ON [DF Voter File].[VOTER ID] = ContactTimes.VorerIDref
GROUP BY [Wd] & " - " & [PR]
HAVING (((Count(ContactTimes.ContactData))=3));

 

[PHV]

but it is giving me odd results
can you please post some input sample, actual result and expected result ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[czarjosh]

well my output is only two records both with counts of 3. there should be at least 50, records, with counts well over three.

 

[PHV]

Are you sure you give us enough infos so we can help you ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[czarjosh]

this is an example of the query before I add the totals rows:

WD PR ContactData
22 1 Bad Contact
22 1 Bad Contact
22 1 Bad Contact
22 1 Bad Contact
22 1 Bad Contact
24 6 Bad Contact
24 6 Bad Contact
24 6 Bad Contact
24 6 Bad Contact
24 6 Bad Contact
24 6 Bad Contact
24 6 Bad Contact
5 2 Bad Contact
5 2 Bad Contact
5 2 Bad Contact
5 2 Bad Contact


*note that 3=Bad Contact* and there are a total of 1157 records.

Now I add the totals row:

SELECT [DF Voter File].WD, [DF Voter File].PR, Count(ContactTimes.ContactData) AS CountOfContactData
FROM [DF Voter File] INNER JOIN ContactTimes ON [DF Voter File].[VOTER ID] = ContactTimes.VorerIDref
GROUP BY [DF Voter File].WD, [DF Voter File].PR
HAVING (((Count(ContactTimes.ContactData))=3));

and the result i get is this:

WD PR CountOfContactData
10 17 3

It is only 1 record.

 

[PHV]

Perhaps you have only one WD,PR pair having 3 same ContactData.
Are you aware that the result you have doesn't corespond with the the input sample you posted ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244