Posted on 2013-06-10
I get an error of Wrong Number of Arguments. Do you see where the error is?
The below use to be an IIF (that worked fine) but I switched it to a "SWITCH" because I needed to add another condition. I imagine it is a syntax somewhere. thank you.
MyGroup: Switch(([tblStatus.Status] Like "*Awarded*" Or [tblStatus.Status] Like "Won*" Or IsNull([ContractAward])=False,"Awarded - within last 60 days", [ATTApprvDate] Is Not Null and [ContractAward] is Null, "Went to ATT but not Awarded", GetGroup([Projects.BidCloseDate],[Projects.ATTApprvDate],[Projects.ATCApprvDate],[Projects.ATSApprvDate],[Projects.ContractAward],[Projects.CorpATTDate],[Projects.ExpectedContractAward])))