Solved

MS Access Report/Chart

Posted on 2013-12-16
5
503 Views
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.
0
Comment
Question by:kawadzi
[X]
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
5 Comments
 
LVL 22

Expert Comment

by:Flyster
ID: 39722952
No sample attached!

Flyster
0
 

Author Comment

by:kawadzi
ID: 39723743
Sorry about that! Attaching....
Seminar-Survey-Tabulation-Exampl.xlsx
0
 
LVL 22

Accepted Solution

by:
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.

Flyster
Seminar-Survey.accdb
0
 

Author Closing Comment

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

Expert Comment

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

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

You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…

732 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