Developer Forum

I am trying to write a Acces query where I only show the part after the ~
sign in a column? I know how to do this in Excel but can't figure it out in
ACCESS. Can anyone give me a hand?

Thanks,

Dear Tim:

How about:

MID(ColumnName, INSTR(ColumnName, "~") + 1)

This is designed to work whether there is a tilda in the column or not.
What do you think? Anywhere close?

Tom Ellison

If the 0~19999 is a string, then you can use the family of string functions

Left, Right, Mid, InStr, InStrRev, and Len

to assist.

Right("My Socks", 5) = "Socks"

--
Steve Clark, Access MVP
http://www.yqcomputer.com/
*FREE* Access Tips: http://www.yqcomputer.com/