Mary Edwards
New member
- Local time
- Today, 07:21
- Joined
- Jun 17, 2020
- Messages
- 10
Hello
I have a database that stores subjects, grades and information about the children. (all in one table)
I need to create a chart as below where it displays a percentage of children in a certain cohort (column) who achieved higher than a grade 2
So x would show the percentage of all children achieving higher than a 2 in English
y would show the percentage of girls achieving higher than a 2 in Maths
etc.
Is there an easier way of doing this then creating a query for each and every box?!
Thanks in Advance!
I have a database that stores subjects, grades and information about the children. (all in one table)
I need to create a chart as below where it displays a percentage of children in a certain cohort (column) who achieved higher than a grade 2
All children | Girls | Boys | Special needs | |
English | x | |||
Maths | y | |||
Science | ||||
Geography |
y would show the percentage of girls achieving higher than a 2 in Maths
etc.
Is there an easier way of doing this then creating a query for each and every box?!
Thanks in Advance!