If Then Error, Wrong # of Arguments

ALewis06

Registered User.
Local time
Today, 12:51
Joined
Jun 21, 2012
Messages
124
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])
 
Ah! Thanks
 

Users who are viewing this thread

Back
Top Bottom