access判断查询的结果是否为空,等同于SQL ISNULL()

Select iif(IsNull( express ), value1, value2 ) From TableName

iif(IsNull( express ), value1, value2 )
相当于:
If express Is Null Then
Return value1
Else
Return value2
End if

posted @ 2013-05-05 15:31  archip  阅读(979)  评论(0编辑  收藏  举报