S
simpleton via AccessMonster.com
I created a nice little Query that totals up all my data.
Problem is, I can't seem to get the Chart-Builder to make this for me
correctly.
Here's what my Query returns:
CategoryID R1 R2 R3 R4 R5 R6 AVG
1 91 91 82 82 82 82 86
2 75 75 75 75 75 75 75
3 100 100 100 100
4 100 86 86 86 100 92
5 100 100 100 100 100
6 75 75 75 50 75 70
7 100 100 75 100 75 92
(sorry for the poor formatting, but i hope you get the idea)
These are obviously percentages (that I totaled based on data)
How in the heck can I get this into a Chart?!?!?
No matter what I try, I keep getting crap.
Problem is, I can't seem to get the Chart-Builder to make this for me
correctly.
Here's what my Query returns:
CategoryID R1 R2 R3 R4 R5 R6 AVG
1 91 91 82 82 82 82 86
2 75 75 75 75 75 75 75
3 100 100 100 100
4 100 86 86 86 100 92
5 100 100 100 100 100
6 75 75 75 50 75 70
7 100 100 75 100 75 92
(sorry for the poor formatting, but i hope you get the idea)
These are obviously percentages (that I totaled based on data)
How in the heck can I get this into a Chart?!?!?
No matter what I try, I keep getting crap.