I'm not even sure I set up my tables correctly to obtain the results I'm seeking. What I can say is that I'm having difficulty with creating a graph from the data my query is giving me. On a monthly basis, I receive service reports for several of the students I serve. I setup a table for each year and the columns basically represent the months in the year. They are yes/no and link to a student table. If I receive a report for the student, I check yes for that month. My query gives me columns of totals for yes responses for each month.
I'm trying to create a graph that will provide a visual image of the number of reports I receive each month. Can someone please point me in the right direction. Thanks, Gregg