V
vanguardaccess
I have a query with the following fields:
Name, Year, Term, Dept, Grade
There are about 10,000 records with repeating entries in any of these
fields. For example:
Tom, 2007, 1, Math, 75
Tom, 2007, 1, Science, 80
Bill, 2006, 2, History, 99
Bill, 2005, 2, History, 87
I want ultimately to have a pivot chart that allows me to show the
percentage of courses passed in each department for each year and term.
I'm having trouble (and need help) creating the query upon which to base the
pivot chart. I don't know how to set up the query so that it groups the
records by year, term, and department, and figures out the percentage of
courses passed in that department. I can do this in report form to get the
results, but I want a graphical view of it (and the ability to see the
percentages change as I filter other information in the query).
Please be clear with your instructions!
Thanks so much!
Name, Year, Term, Dept, Grade
There are about 10,000 records with repeating entries in any of these
fields. For example:
Tom, 2007, 1, Math, 75
Tom, 2007, 1, Science, 80
Bill, 2006, 2, History, 99
Bill, 2005, 2, History, 87
I want ultimately to have a pivot chart that allows me to show the
percentage of courses passed in each department for each year and term.
I'm having trouble (and need help) creating the query upon which to base the
pivot chart. I don't know how to set up the query so that it groups the
records by year, term, and department, and figures out the percentage of
courses passed in that department. I can do this in report form to get the
results, but I want a graphical view of it (and the ability to see the
percentages change as I filter other information in the query).
Please be clear with your instructions!
Thanks so much!