IIF statement combine
Posted on 2011-03-03
I have the following in the reports qry design window divided between 2 groups. Is it possible to combine the two statements into just one "MyGroup". I would have in effect, 4 options based on either [DateApproved] or [DateAmendApprovedbyBank]. Or maybe a sub report would be better but I think it migght slow down the report speed.
MyGroup2: IIf(IsNull([tblLCAmendHistory].[DateApproved]),"Awaiting Amend Approval by Co","Amend Approved by Co")
MyGroup: IIf(IsNull([tblLCAmendHistory].[DateAmendApprovedByBank]),"Awaiting Amend Approval by Bank","Recently Approved Amend by Bank")