Everything But Left 7

N

Nash13

Hello,

I am building a query where I would like to display everything but the left
seven part of the data field. I can do it where it only shows the left seven
but not the other way around. I am looking at this because the left seven are
all the same and everything after than can vary in length.

Here is what I have - WTFID: Right([WTF],7)

Thanks
 
N

Nash13

Worked perfect. Thanks much

Jerry Whittle said:
WTFID: Mid([WTF],8)
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.

Nash13 said:
Hello,

I am building a query where I would like to display everything but the left
seven part of the data field. I can do it where it only shows the left seven
but not the other way around. I am looking at this because the left seven are
all the same and everything after than can vary in length.

Here is what I have - WTFID: Right([WTF],7)

Thanks
Click to expand...
Click to expand...
 
Top