Setting up VBA to count and average what it has counted

[robertmarz]

Basically this is my problem, I would like to count and average data that I have in various fields. What I have is a series of questions that are graded on the following scale 5=100, 4=75, 3=50, 2=25, 1=0. What I would like to do is have VBA or access display how many of each grades are in each catagory, and what each grade averages of the total.

 

[MichaelRed]

A crosstab query will easily give the 'count' of the various grades - for a single column. I often "layer' and join number of these together to get composite reslts like what you are describing. The average(s) need to be done seperatly, however they can usualy be joined to the same grouping as the individual grades. The whole process is usually quite easy to implement, but can be rather slow in execution, especially where you have a lot of records.


MichaelRed
redmsp@erols.com

There is never time to do it right but there is always time to do it over