how to use multiple IIF code in a query?

[markpastoril]

I WANT TO USE THIS CODE DEPENDING THE TYPE OF THE ACCOUNT, THERE ARE 2 TYPES OF ACCOUNT RESIDENTIAL AND COMMERCIAL ACCOUNT.




IF "RESIDENTIAL ACCOUNT" OR (R) ACCOUNT IS TRUE:

THIS CODE WILL RUN
IIf([m3]>=36,((((([m3]-15)-10)-10)*21.56)+472.5),IIf([m3]>=26,(((([m3]-15)-10)*17.25)+300),IIf([m3]>=16,((([m3]-15)*15)+150),IIf([m3]>=15,(150),IIf([m3]>=10,(150),IIf([m3]<=9,[m3]*15,"0"))))))

IF "COMMERCIAL ACCOUNT" OR (C)
IIf([m3]>=36,((((([m3]-15)-10)-10)*43.13)+945),IIf([m3]>=26,(((([m3]-15)-10)*34.5)+600),IIf([m3]>=16,((([m3]-15)*30)+300),IIf([m3]>=15,(300),IIf([m3]>=10,(300),IIf([m3]<=9,[m3]*30,"0"))))))

[June7]

Those are very long expressions. Probably should build a VBA custom function. However, try:

IIf([Account] = "RESIDENTIAL ACCOUNT",

Switch([m3]>=36, (((([m3]-15)-10)-10)*21.56)+472.5, [m3]>=26, ((([m3]-15)-10)*17.25)+300, [m3]>=16, (([m3]-15)*15)+150, [m3]>=10, 150, [m3]<=9, [m3]*15),

Switch([m3]>=36, (((([m3]-15)-10)-10)*43.13)+945, [m3]>=26, ((([m3]-15)-10)*34.5)+600, [m3]>=16, (([m3]-15)*30)+300, [m3]>=10, 300, [m3]<=9, [m3]*30))

[markpastoril]

really works thanks sir?or maam?