Access 2010 Formula of "IFF" and "AND" Error
Posted on 2014-11-18
Can someone help me with this formula? I am trying to create a nested IIF (two statements) with and "AND". Is that doable, and if so, what am I missing? Thanks.
Expr1: IIf(Int((Now()-[Last Received Date])/365)>=2 And IIf(IsNull([Sales / Transfer Qty]),"No","Yes"))