Iif in another Iif with a Right oh my!

[dnlhmpt]

So I am checking for premise numbers with an r or an l in them. If they have either I want to trim the r or l off and then set the length to 9. It has given me many headaches so far!



Originally I had this. It works great too btw!
PremiseNum: Right(IIf([dbo_meterchange].[premisenum] Like "*r",Left([dbo_meterchange].[premisenum],Len([dbo_meterchange].[premisenum])-1),[dbo_meterchange].[premisenum])+1000000000,9)

I have added the new iif and it blows up. Please see below:
PremiseNum: Right(IIf([dbo_meterchange].[premisenum] Like "*r",Left([dbo_meterchange].[premisenum],Len([dbo_meterchange].[premisenum])-1),IIf([dbo_meterchange].[premisenum] Like "*l",Left([dbo_meterchange].[premisenum],Len([dbo_meterchange].[premisenum])-1),[dbo_meterchange].[premisenum])+1000000000,9)

What am I doing wrong here?

Thank you very much!

[June7]

You said if has r or l - so use OR:

PremiseNum: Right(IIf([dbo_meterchange].[premisenum] Like "*r" OR [dbo_meterchange].[premisenum] Like "*l", Left([dbo_meterchange].[premisenum],Len([dbo_meterchange].[premisenum])-1),[dbo_meterchange].[premisenum])+1000000000,9)

[dnlhmpt]

You said if has r or l - so use OR:

PremiseNum: Right(IIf([dbo_meterchange].[premisenum] Like "*r" OR [dbo_meterchange].[premisenum] Like "*l", Left([dbo_meterchange].[premisenum],Len([dbo_meterchange].[premisenum])-1),[dbo_meterchange].[premisenum])+1000000000,9)

Thank you very much! This worked like a charm!