Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Posts
    294
    Thanks
    0
    Thanked 0 Times in 0 Posts

    right$ (Access 2003 )

    I'm trying to isolated a string of text in a field in a query. The string of characters i need is 50 through 55 in the string of 100. I can use the right$(field,49) function to pull off the first 49 characters but what can I do to remove the end of the string 56 through 100? Thanks...

  2. #2
    5 Star Lounger st3333ve's Avatar
    Join Date
    May 2003
    Location
    Los Angeles, California, USA
    Posts
    705
    Thanks
    0
    Thanked 2 Times in 2 Posts

    Re: right$ (Access 2003 )

    Mid$(field,50,6)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •