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

[SurreyNick]

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?

 

[Ranman256]

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]

Did it. Thanks.