MS Access Report/Chart

Posted on 2013-12-16
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
  • 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 500 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

Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

Question has a verified solution.

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

Suggested Solutions

Introduction The Visual Basic for Applications (VBA) language is at the heart of every application that you write. It is your key to taking Access beyond the world of wizards into a world where anything is possible. This article introduces you to…
Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

821 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