TechSpot - PC Technology News and Analysis

Hi, All!

I have an Access 95 database with numerous option groups to capture ratings (using 1 to 5) on various customer-service questions. My problem is getting the reporting function to tell me how many 1s, how many 2s, etc., for each of the approximately 20 questions. So far I can only get it to return which number was marked, but not a total of each rating.

I tried doing a query with the totals and then making another query based on
that but using the Count Total function, but that didn't work either. I'm not
sure how to get these totals of each rating for each of the option groups. Is
it even possible with an option group to set up such reporting? Would the
option groups need to be changed to individual checkboxes (ugh!)?

Please note that while I am comfortable with Access' design interface, I am
not a programmer, so your answers may need to be "dumbed down" for me.

Many thanks for your help!!!

You need the select sum function
http://www.techonthenet.com/sql/sum.php