Search results

Hi All Can anyone help me with an IIF statement that is going wrong please? In a query, I have the following IIF statement in the criteria of a long integer field: IIf([Forms]![frmSupplierNCRsReviewSelection]![fraErrorCode]=1,>0, In (1,5,6,7)) The IIF statement is getting and using the...

Bit of a newbie at all this. I understand simple relationships, but some confuse me. I've looked at other posts in forums, downloaded sample databases, but not been able to find anything quite like this? I've come across this problem before, and am not sure how to resolve it.. A simple music...