Grouping by in a graph

[kdevitt]

HI,

I'm having big problems getting a seemingly easy graph to work. It's the very last part of a fairly extensive db, so I want to get it out of the way ASAP!

The recordsource for the graph a table like below:

Grade: Q1 Q2.... Name
Great 0 1 John B
Ok 1 2 John B
Bad 2 0 John B
Great 2 2 Ken D
Ok 1 0 Ken D
Bad 0 1 Ken D

I want one graph for each person to show their total number of great,ok and bad results.

I've bound the report to the staff table which holds the individuals names, and tried the use it as a master, with a name in the graph as the child field.

When I run the report I'm getting the correct graph 3 times for each person. I've just hit a brick wall and can't think straight anymore!!

Any help/ideas/money would be greatly appreciated!!

Ken

 

[kdevitt]

You can ignore this now!!

I finally got it working