Left or Right

[Dale Fye]

When you need everything to the right of a certain character, you can use the
Mid function. In your case, you would use Mid([fieldName], 7).

You can also use this to capture a fixed width from within a string by
adding the optional parameter on the end which tells it how many characters
to grab.

HTH
Dale

 

[bootybox via AccessMonster.com]

Works most prefectly!
Thanks
DS

When you need everything to the right of a certain character, you can use the
Mid function. In your case, you would use Mid([fieldName], 7).

You can also use this to capture a fixed width from within a string by
adding the optional parameter on the end which tells it how many characters
to grab.

HTH
Dale

I have field that has this in it...
042507333

[quoted text clipped - 4 lines]

Thanks
DS

 

[DS]

I have field that has this in it...
042507333
the first 6 being the date...I need to get the last 3 digits (In this case),
I would use Right but it's not always going to be three digits, sometimes 1,
sometimes 4 I have know way of knowing . How can I get these digits minus
the first 6?
Thanks
DS