Data type mismatch

[Kinger43]

I have a query that strips the first letter of a string that is a combination of letters and numbers. I have this field in the query:

Expr2: Right([ILOCATIO]![Line_Pole_No],Len([ILOCATIO]![Line_Pole_No])-1)

This portion works fine, now I need to put criteria on this field to only return the records where this field contains a "U". I used Like "*U*" in the cirteria and it keeps giving me a Data Type Mismatch error. Line_Pole_No is a text string to begin with and the help says that the Right function returns a variant (String). I don't understand where the data type mismatch is coming from. I have tried using CVar and CStr functions to force them to match and it gives me the same error.

 

[raskew]

Try Instr("YourString", "U")>0

A simpler way of returning all but the first character might be:

mid([ILOCATIO]![Line_Pole_No],2)

HTH - Bob