I am alive
Member
- Local time
- Today, 02:49
- Joined
- Aug 29, 2020
- Messages
- 139
The logic behind this is that if you want to get CLASSMEANSCORE you sum the Meanscore of Subjects done divided by the subjects done which will give us 50.83333. Then in Excel we use IF as I have shown. Kindly assist me now in ms access based on database. Thanks in advance.Ignore the other one and use this one. Check on the "RED"
You are genius. My database is complete thanks to you. God bless you so much. It works perfectlyhere give it a try.
Hi @arnelgp how can I print only 7 best perfomed Subjects from this crosstab query. Kindly have a look at qryGrades.here give it a try.