I have a table (Table1) that looks like this:
ID Name FruitCode
1 Name1 14
2 Name2 11
3 Name3 11
4 Name4 8
5 Name5 11
FruitCode represents each student's favourite fruit, i.e.
Fruit FruitCode
Apple 8
Pear 11
Grapes 14
My goal is to create a report with a pie...