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

原文地址:https://www.cnblogs.com/archip/p/3061051.html