Nested Iif query

[yvettethiart]

HI Guys

I have different product groups and they can have one of 3 rental rates(5,4,3%) I have written a nested query but I keep getting parenthesis errors, the last one I got told me I must enclose iif functions in parentheses. I know its probably a small thing but I just cant see it. By the way the server is German so ; need to be used instead of ,.

IIf([view_India]![Sub_Group] In (1730;1810;2870);5;iif Left([view_India]![Sub_Group];2) In (01;02;21;24;29)
;5;iif([view_India]![Sub_Group] In (3310;3330;3340;3360);3;4))))

Can someone point me in the right direction?

 

[CJ_London]

you are missing a bracket and some quotation marks and looks like an extra bracket at the end

IIf([view_India]![Sub_Group] In (1730;1810;2870);5;[COLOR=red]iif Left[/COLOR]([view_India]![Sub_Group];2) In ([COLOR=red]01;02;21;24;29[/COLOR])
;5;iif([view_India]![Sub_Group] In (3310;3330;3340;3360);3;4)))[COLOR=red])[/COLOR]

 

[yvettethiart]

Thanks CJ, I missed the bracket before left and had an extra bracket at the end!! Just needed the extra eyes!!