I am on the first portion of a long IF Then statement and I can't even get the first portion to work. The error is "wrong number of arguments". Please tell me what I am doing wrong.
ProjRevMRC: IIf([Rev Lag]=30 And [ProjRevDate]<= DateSerial(Year(Date()),Month(Date()),+1,0),0,[qry805_SFADetailMRC_ONLY]![CurrentMRC]*[qry805_SFADetailMRC_ONLY]![Rev Flow Through])
ProjRevMRC: IIf([Rev Lag]=30 And [ProjRevDate]<= DateSerial(Year(Date()),Month(Date()),+1,0),0,[qry805_SFADetailMRC_ONLY]![CurrentMRC]*[qry805_SFADetailMRC_ONLY]![Rev Flow Through])