1.判空 Access: Nz 同Sql Server IsNull。只能在Access程序中使用,Jet ADO不支持 select userName,Nz(address,'无') from [user]... IIF select userName,IIF(address is null,'无',address) from [user]... select userName,IIF(address is null,'没写','写了') from [user]...