Ok, I'm an Access noob here looking for help.
I have a table that we have been using to track responses we get on patient satisfaction cards. These cards get dropped into comment boxes and have 7 multiple choice questions and an area for comments.
The table has a table like this:
ID Location Date Recvd Site Q1 Q2 Q3 Q4 Q5 Q6 Q7 Comments 1 box 1 1/23/2013 main Yes, Always Yes, Definitely Yes, Somewhat No Yes, Sometimes Excellent 5 blah 2 box 2 12/14/2011 clinic 1 No Yes, Somewhat Yes, Definitely Yes, Always No Poor 7 blah blah
How can I generate a report showing a graph of the count of each response per quarter?