[MS_AccessPros] Monthly Count

 

I have the following query that returns a count based on activity dates by the month:

SELECT Count(tblLearningCenterClientActivities.StudentID) AS [Total Students], Format(Month([ActivityDate]),"mmmm") AS [Month of Activity]
FROM tblLearningCenterClientActivities
WHERE (((tblLearningCenterClientActivities.ActivityDate)>#1/1/2011#))
GROUP BY Format(Month([ActivityDate]),"mmmm"), tblLearningCenterClientActivities.LearningCenterID
HAVING (((tblLearningCenterClientActivities.LearningCenterID)=1));

But it only returning a count in January even though I know there are activities in feburary. Confused!!!

Thanks
Art Lorenzini
Sioux falls

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (1)

Recent Activity:

• New Members 14
• New Files 6

Visit Your Group

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___