或者直接用表达式列:
iif(A< 60,"不及格",iif(A>=60 And A <80,"优良",iif(A >= 80,"优秀","")))
参考:
http://www.foxtable.com/help/topics/0104.htm
http://www.foxtable.com/help/topics/0102.htm