MS Access Report/Chart

Posted on 2013-12-16
Medium Priority
Last Modified: 2013-12-17
I have a database setup to collect results of surveys on seminars.  There are different seminars, and 9 different items to track.  The 9 items are in groups of 3 - first group reponses are Excellent, Very Good, Good, Fair and Poor; 2nd group are Very Likely, Somewhat Likely and Not Likely, 3rd group are Agree, Neutral and Disagree. I have set up forms to collect results, and that works fine.  What I need to do next is to be able to tabulate the results by seminar and rating, and create reports and charts from that.  

I am finding it had to summarize the results by rating -- I think this should be fairly simple, but having trouble getting to the right results. Crosstab queries do not work; I cannot group by rating. I tried to create a summary query to count the ratings, but need to create an individual query for each of the 9 items, and then combine them into one query, which I think is much too cumbersome.  Does anyone know of any easier way to accomplish this?  

Attached is sample of my data - first tab shows the table that holds the survey results. 2nd tab is a sample of what I am trying to accomplish. I would eventually want to use those results to create graphs and reports by seminar or for all seminars.

Thank you.
Question by:kawadzi
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
LVL 22

Expert Comment

ID: 39722952
No sample attached!


Author Comment

ID: 39723743
Sorry about that! Attaching....
LVL 22

Accepted Solution

Flyster earned 2000 total points
ID: 39724875
See if this is what you're looking for. I added a table call ratings which is used to group the results. qrySurvey_Results uses a formula that gives a value of 1 if it matched the rating, I.E.:

Speaker_Skills: Sum(IIf([SpeakerSkills]=[Rating],1,0))

Those values are then totaled up for each seminar ID and rating.


Author Closing Comment

ID: 39725387
This is really great - EXACTLY what I was looking for in one simple query.  Thanks ever so much!
LVL 22

Expert Comment

ID: 39725565
My pleasure. Glad I could help out!

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
Code that checks the QuickBooks schema table for non-updateable fields and then disables those controls on a form so users don't try to update them.
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

719 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question