SurreyNick
Member
- Local time
- Today, 00:55
- Joined
- Feb 12, 2020
- Messages
- 127
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?
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: