Get a count of records returned. 1

[bosk00]

We coach hearings for our clients. I have a simple database with entrys for each hearing. I have a query that starts with the contract month for our clients, and then brings back the hearings for each client within a time frame. What I really need is the total of hearings for each client, not the individual hearings.

SELECT Q.T01CONDTM, H.[Date of Hearing], H.Company
FROM QAMAIN Q INNER JOIN [Hearing Data] H ON Q.COMPANY = H.Company
WHERE (((Q.T01CONDTM)=[Enter Contract Month]) AND ((H.[Date of Hearing]) Between [Enter Beginning Date] And [Enter Ending Date]))
WITH OWNERACCESS OPTION;

I am unclear on how to add Count(). All help is appreciated.
Thank You

Alan
Senility at its finest

 

[PHV]

You may try this:
SELECT Q.T01CONDTM, H.Company, Count(*) As CountOfHearings
FROM QAMAIN Q INNER JOIN [Hearing Data] H ON Q.COMPANY = H.Company
WHERE (((Q.T01CONDTM)=[Enter Contract Month]) AND ((H.[Date of Hearing]) Between [Enter Beginning Date] And [Enter Ending Date]))
GROUP BY Q.T01CONDTM, H.Company;

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

 

[bosk00]

Thank you very much. That did it.

Alan
Senility at its finest