وعليكم السلام 🙂
اذا كان في حقل الاستعلام شروط كثيرة ، فأنا الجأ الى الوحدة النمطية لتسهيل الامر ، وهذا ما فعلته هنا 🙂
.
والنتيجة
.
والوحدة النمطية:
Option Compare Database
Option Explicit
Public Function Per(Deg As String) As String
'Expr1: IIf([Deg1]="غـ","متخلف",IIf(((Val([Deg1])/20)*100)<50,"Less50",IIf(((Val([Deg1])/20)*100) Between 50 And 55,"50-55%",IIf(((Val([Deg1])/20)*100) Between 55.1 And 60,"55-60%",IIf(((Val([Deg1])/20)*100) Between 60.1 And 65,"60-65%",IIf(((Val([Deg1])/20)*100) Between 65.1 And 70,"65-70%",IIf(((Val([Deg1])/20)*100) Between 70.1 And 75,"70-75%",IIf(((Val([Deg1])/20)*100) Between 75.1 And 80,"75-80%",IIf(((Val([Deg1])/20)*100) Between 80.1 And 85,"80-85%",IIf(((Val([Deg1])/20)*100) Between 85.1 And 90,"85-90%",IIf(((Val([Deg1])/20)*100) Between 90.1 And 95,"90-95%",IIf(((Val([Deg1])/20)*100) Between 95.1 And 99.99,"95-99%","100%"))))))))))))
Dim Grade As Double
Grade = ((Val(Deg) / 20) * 100)
If Deg = "غـ" Then
Per = "متخلف"
ElseIf Grade < 50 Then
Per = "Less50"
ElseIf Grade >= 50 And Grade <= 55 Then
Per = "50-55%"
ElseIf Grade >= 55.1 And Grade <= 60 Then
Per = "55-60%"
ElseIf Grade >= 60.1 And Grade <= 65 Then
Per = "60-65%"
ElseIf Grade >= 65.1 And Grade <= 70 Then
Per = "65-70%"
ElseIf Grade >= 70.1 And Grade <= 75 Then
Per = "70-75%"
ElseIf Grade >= 75.1 And Grade <= 80 Then
Per = "75-80%"
ElseIf Grade >= 80.1 And Grade <= 85 Then
Per = "80-85%"
ElseIf Grade >= 85.1 And Grade <= 90 Then
Per = "85-90%"
ElseIf Grade >= 90.1 And Grade <= 95 Then
Per = "90-95%"
ElseIf Grade >= 95.1 And Grade <= 99.99 Then
Per = "95-99%"
Else
Per = "100%"
End If
End Function
جعفر
1022.Problem 55-2003.mdb.zip