In MS Access how do a only show the 19999 of 0~19999 in a column?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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"
 
Back
Top