Count from option group?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!!!
 
opus88 said:
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!!!
Click to expand...

Getting this from a query is trivial for ONE question...

SELECT Question1, Count(*) as qty
FROM TableName
GROUP BY Question1

....but would be difficult for more than one question because your basic table
design is flawed. Instead of a field per question you should have had a second
related table so that all question values are in a single field with an
additional field to identify the question. Such a table would look like...

QuestionID QuestionResponse
1 1
2 3
3 5
4 2
1 5
4 4
etc...
 
Back
Top