Solved Query to show records where X% of cohort got less than X% achievement? (1 Viewer)

SurreyNick

Member
Local time
Today, 03:44
Joined
Feb 12, 2020
Messages
125
I’m trying to generate a recordset based upon two user-defined criteria - a list of those subjects where 80% of the class cohort scored less than 20% of possible maximum marks. The two percentages (80%) and (20%) will be user-defined but I will set the defaults at these levels.

A query to produce a dataset of those students in a class who have scored less than 20% in a subject is simple enough, but I have been struggling to work out how to do the first part i.e. only return those subjects if 80% of the students in the class got less than the 20%

Any ideas how I might do this?
 
Last edited:

Ranman256

Registered User.
Local time
Yesterday, 22:44
Joined
Apr 9, 2015
Messages
3,638
Make Q1 to get the totals .
Then Q2 to get what was accomplished.
Then Q3 ,bring in Q1 & Q2 ,and set yr criteria % results.
 

SurreyNick

Member
Local time
Today, 03:44
Joined
Feb 12, 2020
Messages
125
Did it. Thanks.
 

Users who are viewing this thread

Top Bottom