Average query

K

kaelwithme

I am developing an attendace tracking system which accepts numerical values
instead of options like Present: Yes/No.

now, I want to compute the average of the attendance of an activity for the
whole month/week.

Most of the activities are on sunday so i kinda thought that i have to do
some calculations like :

(Add all values in the said date(sunday) then divide by (the number of
sundays in the month)

i have an input in my front end program (VB) which asks for the date in a
date format (mm/dd/yyyy) for a specific activity,. here is an example of an
input. Toddlers Class(Activity) 198(Total Attendace) 08/21/2009 (date) ...


now how would i get the average of all the toddlers class for the month of
say, august?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top