IIf Statement Syntax Error

[shexe]

I continue to receive a syntax error in a nested IIf statement. I am not seeing it but Access keeps highlighting the AS before AprilPercent. Can someone help me de-dug this?




IIf(([MasterResource-Query].ResourceType="Contractor",IIf(Month([MasterResource-Query].EndDate)<4 And Year([MasterResource-Query].EndDate)=2010,1,NonBillable_2010.April/(22*[MasterResource-Query].AllocationPercent))

IIf([MasterResource-Query].ResourceType="Intern",IIf(Month([MasterResource-Query].EndDate)<4 And Year([MasterResource-Query].EndDate)=2010,1,NonBillable_2010.April/(20*[MasterResource-Query].AllocationPercent))

IIf([MasterResource-Query].ResourceType="Employee",IIf(Month([MasterResource-Query].EndDate)<4 And Year([MasterResource-Query].EndDate)=2010,0,NonBillable_2010.April/(20*[MasterResource-Query].AllocationPercent))

IIf(Month([MasterResource-Query].EndDate)<4,1,NonBillable_2010.April/(22*[MasterResource-Query].AllocationPercent))) AS AprilPercent

Thanks,
Sam

[ajetrumpet]

shexe,

a syntax error almost always means that there is a problem parsing the expression out. what that means is that you either left out a character, have too many, or something else that's small. usually it is hard to spot.

IIf(([MasterResource-Query].ResourceType="Contractor",IIf(Month([MasterResource-Query].EndDate)<4 And Year([MasterResource-Query].EndDate)=2010,1,NonBillable_2010.April/(22*[MasterResource-Query].AllocationPercent))

IIf([MasterResource-Query].ResourceType="Intern",IIf(Month([MasterResource-Query].EndDate)<4 And Year([MasterResource-Query].EndDate)=2010,1,NonBillable_2010.April/(20*[MasterResource-Query].AllocationPercent))

IIf([MasterResource-Query].ResourceType="Employee",IIf(Month([MasterResource-Query].EndDate)<4 And Year([MasterResource-Query].EndDate)=2010,0,NonBillable_2010.April/(20*[MasterResource-Query].AllocationPercent))

IIf(Month([MasterResource-Query].EndDate)<4,1,NonBillable_2010.April/(22*[MasterResource-Query].AllocationPercent))))) AS AprilPercent

The problem that is immediately visible is your number of outside closing backets. The ones is red that I put in should be added.

you may have been getting confused with the second IIF() statement in each of those blocks. each block is short one ")" character.

[shexe]

You got it - Thanks again!