Results chart

[Mary Edwards]

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

	All children	Girls	Boys	Special needs
English	x
Maths		y
Science
Geography

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!

 

[arnelgp]

you may try crosstab query or a simple select query.
plz post some data.

 

[Mary Edwards]

grades between 0-4

 

[mike60smart]

Hi Mary

Here is one way

 

[isladogs]

As each 'box' will contain a different group of students you will need to do a separate query for each,
However in order to get % values, just use an aggregate query in each case.

You may find my Student Target Grade Explorer example app useful as it deals with a very similar issue ... and more http://www.mendipdatasystems.co.uk/multiple-group-filter/4594454290

 

[arnelgp]

maybe not what you need (Query1).