Results chart (1 Viewer)

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
All childrenGirlsBoysSpecial needs
Englishx
Mathsy
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

..forever waiting... waiting for jellybean!
Local time
Today, 15:21
Joined
May 7, 2009
Messages
19,169
you may try crosstab query or a simple select query.
plz post some data.
 

Mary Edwards

New member
Local time
Today, 07:21
Joined
Jun 17, 2020
Messages
10
grades between 0-4
 

Attachments

  • Example v1.accdb
    372 KB · Views: 82

mike60smart

Registered User.
Local time
Today, 07:21
Joined
Aug 6, 2017
Messages
1,899
Hi Mary

Here is one way
 

Attachments

  • Example v1.zip
    22.7 KB · Views: 94

arnelgp

..forever waiting... waiting for jellybean!
Local time
Today, 15:21
Joined
May 7, 2009
Messages
19,169
maybe not what you need (Query1).
 

Attachments

  • Example v1.accdb
    460 KB · Views: 88

Users who are viewing this thread

Top Bottom