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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Tim S - 21 Mar 2006 01:20 GMT

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,

Reply to this Message

Tom Ellison - 21 Mar 2006 05:27 GMT

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

>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,

Reply to this Message

[MVP] S.Clark - 21 Mar 2006 06:32 GMT

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"

Signature

Steve Clark, Access MVP
http://www.fmsinc.com/consulting
*FREE* Access Tips: http://www.fmsinc.com/free/tips.html

Reply to this Message