Hello all
I designed a query which works well
What I want is: -
1. If the value of the field (Expr1) from 80 to 100 selects the value of the field (Computer)
2. If the value of the field (Expr1) from 70 to 80 selects the value of the field (Maths)
3. If the value of the field (Expr1) from 60 to 70 selects the value of the field (Statistics)
4. If the value of the field (Expr1) from 50 to 60 selects the value of the field (Medical)
Thanks in advance
SELECT tbStudents.StuID, tbStudents.NoAccepCentral, tbStudents.StudentName, tbStudents.TotalScores, Table1.Computer, Table1.Maths, Table1.Statistics, Table1.Medical, [TotalScores]/7 AS Expr1
FROM tbStudents INNER JOIN Table1 ON tbStudents.StuID = Table1.id;