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

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

QuickBooks® has a great invoice interface that we were happy with for a while but that changed in 2001 through no fault of Intuit®. Our industry's unit names are dictated by RUS: the Rural Utilities Services division of USDA. Contracts contain un…
I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
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 use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

790 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