IIF不喜欢Access 2007中的语句

Question

我试图使这个QC显示文件失败的原因。我已到位的QC工作很好，但当我试图给出理由，所有的工作，除了无效的邮编。如果QC捕获和错误的任何其他原因是给出的理由，以及一个无效的邮政编码。我把我的理由逻辑放在了下面，并指出了我认为有这个问题的领域。

Reason: IIf([CNMC Import.Gf_Date] Is Null,"No gift date, ","") & IIf([CNMC Import.Gf_Amount] Is Null,"No gift amount, ","") &
IIf([CNMC Import.Gf_CnBio_Key_Indicator] Is Null,"No individual or organization indicator, ","") &
IIf([CNMC Import.Gf_CnAdrSal_Addressee] Is Null,"No Addressee, ","") &
IIf([CNMC Import.Gf_CnAdrSal_Salutation] Is Null,"No Salutation, ","") &
IIf([CNMC Import.Gf_CnAdrPrf_Addrline1] Is Null,"No street address, ","") &
IIf([CNMC Import.Gf_CnAdrPrf_City] Is Null,"No city, ","") &
IIf([CNMC Import.Gf_CnAdrPrf_State] Is Null,"No state, ","") &
IIf([CNMC Import.Gf_CnAdrPrf_ZIP] Is Null,"No Zip Code, ","") & 
**IIf(([CNMC Import.Gf_CnAdrPrf_ZIP] Not Like "#####-####" & [CNMC Import.Gf_CnAdrPrf_ZIP]) Not Like "#####","Invalid zip code, ","")**

Answer 1

试试这个(使用IIf 2次)：

IIf([CNMC Import.Gf_CnAdrPrf_ZIP] Like "#####-####", ",", IIf([CNMC Import.Gf_CnAdrPrf_ZIP]) Like "#####", ",", "Invalid zip code")

Answer 2

如果您试图组合两个检查，那么您就不能使用&符号，它只是将字符串合并在一起。

而不是

IIf(([CNMC Import.Gf_CnAdrPrf_ZIP] Not Like "#####-####" & [CNMC Import.Gf_CnAdrPrf_ZIP]) Not Like "#####","Invalid zip code, ","")

试一试

IIf([CNMC Import.Gf_CnAdrPrf_ZIP] Not Like "#####-####" AND [CNMC Import.Gf_CnAdrPrf_ZIP] Not Like "#####","Invalid zip code, ","")