MS Access Report/Chart

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.
kawadziAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

FlysterCommented:
No sample attached!

Flyster
0
kawadziAuthor Commented:
Sorry about that! Attaching....
Seminar-Survey-Tabulation-Exampl.xlsx
0
FlysterCommented:
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
kawadziAuthor Commented:
This is really great - EXACTLY what I was looking for in one simple query.  Thanks ever so much!
0
FlysterCommented:
My pleasure. Glad I could help out!
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.