more expression help

[tubar]

IIf([MANUFACTOR SENT]=2,[GE PART #])

this expression works fine in my querry....but i need to add to it...if the user doesnt choose 2...if he chooses 1 then i need the sylvania part number or if he chooses 3 i need the phiilips part number....so i used this expression

IIf([MANUFACTOR SENT]=2,[GE PART #])IIf([MANUFACTOR SENT]=1,[sylvania PART #])IIf([MANUFACTOR SENT]=3,[phillips PART #])

but i get errors....how do you you string the expression...or what should i do to fix

 

[Ziggy1]

your commas and brackets are in the wrong place..


IIf([MANUFACTOR SENT]=2,[GE PART #],IIf([MANUFACTOR SENT]=1,[sylvania PART #],IIf([MANUFACTOR SENT]=3,[phillips PART #],"N/A")))



IIf([MANUFACTOR SENT]=2,TRUE,FALSE)