Hello!
I have a students table with the following details:
Reg no, Name, Subject, Category, Points
1324, Silas, English, Compulsory, 10
1324, Silas, Kiswahili, Compulsory, 11
1324, Silas, Maths, Compulsory, 12
1324, Silas, Biology, Science, 9
1324, Silas, Chemistry, Science, 10
1324, Silas, Physics, Science, 9
1324, Silas, History, Humanity, 8
1324, Silas, Geography, Humanity, 11
1324, Silas, Computer studies, Applied, 10
- My aim is to compute student total points based on the following criteria:
- Points of all compulsory subjects are included in the total then STRICTLY four best points
of the remaining subjects are added to the compulsory ones.
- For example the above data should yield the following:
- {10+11+12} + {11+10+10+9} = 73 points.
- The output is based on a cross tab query which generates a list of all the student.
- Any help will be appreciated.
- Thanks in advance.
I have a students table with the following details:
Reg no, Name, Subject, Category, Points
1324, Silas, English, Compulsory, 10
1324, Silas, Kiswahili, Compulsory, 11
1324, Silas, Maths, Compulsory, 12
1324, Silas, Biology, Science, 9
1324, Silas, Chemistry, Science, 10
1324, Silas, Physics, Science, 9
1324, Silas, History, Humanity, 8
1324, Silas, Geography, Humanity, 11
1324, Silas, Computer studies, Applied, 10
- My aim is to compute student total points based on the following criteria:
- Points of all compulsory subjects are included in the total then STRICTLY four best points
of the remaining subjects are added to the compulsory ones.
- For example the above data should yield the following:
- {10+11+12} + {11+10+10+9} = 73 points.
- The output is based on a cross tab query which generates a list of all the student.
- Any help will be appreciated.
- Thanks in advance.