If the value of the field

[azhar2006]

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;

[RuralGuy]

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;

Computers are real dumb but very precise. 80 could qualify for 1 or 2 as do the others with overlapping values.

[A S MANN]

Try
Field:IIF([Expr1] >= 80,[Computer], IIF([Expr1] >= 70,[Maths],IIF([Expr1] >= 60,[Statistics],
IIF([Expr1] >= 50,[Medical]," " ))))

[azhar2006]

Thank you very much

[A S MANN]

Mark as resolved if Issue is solved.