Hi,
I have function. How correctly add condition: case isnull then "no data"?
Option Compare Database
Public Function AssignGrade(studScore As Single) As String
Select Case studScore
Case 0 To 100
AssignGrade = "A"
Case 101 To 200
AssignGrade = "B"
Case 201 To 1000
AssignGrade = "C"
Case Else
AssignGrade = "F"
End Select
End Function
I have function. How correctly add condition: case isnull then "no data"?
Option Compare Database
Public Function AssignGrade(studScore As Single) As String
Select Case studScore
Case 0 To 100
AssignGrade = "A"
Case 101 To 200
AssignGrade = "B"
Case 201 To 1000
AssignGrade = "C"
Case Else
AssignGrade = "F"
End Select
End Function
Last edited: