IIf statement syntax problem

[simon551]

Hi. I'm having a hard time getting the syntax of this multi-IIf statement correct. If you can help me I'd really appreciate it.

it's giving me an error message of: 'Wrong number of arguments used with query expression.'

SELECT  tblMembershipsProcessed.processDate, tblMembershipsProcessed.amountPaid, Month([processDate]) AS processMonth, Year([processDate]) AS processYear, 

IIf([processYear]=2008,IIf([processMonth]<=2,Round(([AmountPaid]/12),2),
IIf([processYear]=2007,IIf([processMonth]>=2,Round(([AmountPaid]/12),2),0),0),0),0) AS [Feb 08]

FROM tblMembershipsProcessed

Thanks!

 

[SkipVought]

IIf([notified]=2007,IIf([notified]>=2,Round(([notified]/12),2),0),0)),0)  AS [Feb 08]

or

IIF([ProcessDate]>=#2/1/2007# and [ProcessDate]<=#2/29/2007#,Round(([AmountPaid]/12),2),0)

Skip,

_{Did you hear what happened when the OO programmer lost his library?...
He's now living in OBJECT poverty!}