Everything But Left 7

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

Guest

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