[MS_AccessPros] Get a weekly average

 

I am working on a query that should pull the average number of students participating in an activity on a weekly basis. The following query returns a count of students that attended a actvitiy on a monthly basis:

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

Is there way to tweek this one to pull the weekly average?

Thanks,

Arthur Lorenzini
Sioux Falls, SD

__._,_.___

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

Messages in this topic (1)

Recent Activity:

• New Members 13
• New Files 6

Visit Your Group

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

.

__,_._,___