Select Case e.DataCol.Name Case "得分" If e.NewValue > 90 AndAlso e.NewValue <= 100 Then e.DataRow("评价") = "优秀" Else If e.NewValue > 80 AndAlso e.NewValue <= 90 Then e.DataRow("评价") = "优良" Else e.DataRow("评价") = "其它" End If
End Select
表达式列这样用 :IIF([得分] <= 100 and [得分] > 90,'优秀',IIF([得分] <= 90 and [得分] > 80,'优良','其它'))