IIF Not like statement in Access 2. I am trying to make this QC display the reason for the file failing. The QC I have in place works great but when I try to give the reason all work with the exception of the invalid Zip Code. If the QC catches and error for any other reason is gives that reason as well as an invalid zip code. I have placed my reason logic below and pointed out the area I believe to have the issue. YU2D.png' alt='Microsoft Access Iif Is Not Null Sql' title='Microsoft Access Iif Is Not Null Sql' />Reason IIfCNMC Import. GfDate Is Null,No gift date, IIfCNMC Import. GfAmount Is Null,No gift amount, amp. IIfCNMC Import. GfCn. BioKeyIndicator Is Null,No individual or organization indicator, amp. IIfCNMC Import. GfCn. Adr. SalAddressee Is Null,No Addressee, amp. Microsoft Access Iif Is Not Null Sql' title='Microsoft Access Iif Is Not Null Sql' />I have tried adding a simple filter to my reports recordset, but I cant make it NOT filter when blanknull. For example, I want the user to be able to filter. Over 100 tips for creating faster Microsoft Access databases by optimizing and improving their performance in your applications. Microsoft Access Query Design Articles, Topics and Tutorials. Here you will find articles and tutorials relating to Microsoft Access query designs, from. I have a query that does not find a mtaching record in joined table. When this happens the field has error in it. How do I replace the error with 0IIfCNMC Import. GfCn. Adr. SalSalutation Is Null,No Salutation, amp. IIfCNMC Import. GfCn. Adr. PrfAddrline. Is Null,No street address, amp. IIfCNMC Import. GfCn. Adr. PrfCity Is Null,No city, amp. IIfCNMC Import. ok i think I have something that works, see what yous think. SELECT CASE WHEN SUMcolumnOne IS NULL THEN Bad WHEN SUMcolumnOne 0 THEN Bad. Microsoft Access 2010 comprehensive list all Error Numbers and Descriptions. I am trying to make this QC display the reason for the file failing. The QC I have in place works great but when I try to give the reason all work with the exception. In SQL, a completely empty field is said to be NULL. For NULL searches you do not use equals, but rather the special operator IS NULL SELECT FROM table WHERE. GfCn. Adr. PrfState Is Null,No state, amp. IIfCNMC Import. GfCn. Adr. PrfZIP Is Null,No Zip Code, amp. IIfCNMC Import. GfCn. Adr. PrfZIP Not Like CNMC Import. GfCn. Adr. PrfZIP Not Like ,Invalid zip code, ,. Opera Mini 7 Handler Java Download.