IIf STATEMENT - MS QUERY

[lwarren1968]

I have an express below that works well when the data meets the specified criteria. However, I need all data to be returned not just those adjusted based on the expression below. What am I missing?


Expr2: IIf(Len([Expr1])=13,Left([Expr1],12),IIf(Len([Expr1])=12,Left([Expr1],11)))

 

[theDBguy]

Hi. I'm not sure I understand, but maybe try this?


Expr2: IIf(Len([Expr1])=13,Left([Expr1],12),IIf(Len([Expr1])=12,Left([Expr1],11),[Expr1]))

 

[lwarren1968]

That is exactly what I needed. Works perfectly. Thank you!

 

[theDBguy]

That is exactly what I needed. Works perfectly. Thank you!

Lucky guess. Glad to hear you got it to work. Good luck with your project.

 

[arnelgp]

to simplify your IIFs:

Expr2: IIf(Len([Expr1])>11, Left([Expr1],LEN([Expr1])-1), [Expr1])