Problem with Count query with Group by

[BennyLinton]

I am trying to count the number of people with a particular credential (qualifying credential, (numerical)) within a date range:

SELECT DISTINCTROW Count(*) AS [Count Of dbo_People]
FROM dbo_People INNER JOIN dbo_certs ON dbo_People.peopleId = dbo_certs.peopleId
WHERE (((dbo_certs.applicationDate) Between [Beginning Date:] And [Ending Date:]))
GROUP BY dbo_certs.applicationDate, dbo_People.qualifyingCredential;

Problem is my results are looking like this and I need them to be grouped (like 1: 13, 2: 5, 3: 6, etc.):

1
1
2
3
3
2
2
1
2
3
3
4
1
4
2
5

 

[theDBguy]

Hi. It seems in your SQL, you are grouping by a date field. What is the actual grouping category you want to use?

 

[BennyLinton]

That was the problem.... thanks! didn't need to group by date

 

[theDBguy]

That was the problem.... thanks! didn't need to group by date

Hi. Glad to hear you got it sorted out. Cheers!