Results 1 to 3 of 3
  1. #1
    4 Star Lounger
    Join Date
    Jun 2001
    Location
    Sacramento, California, USA
    Posts
    491
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Truncation (WIN 2000 Acc 97)

    I know I have asked this before, (and it was answered, thank you !!) but I just cannot find my post.

    It concerns truncation in an update query.

    I have a field with data that looks like this:
    WH1234, WH232211, WHabc132 etc..........
    What I need to do is get rid of the WH only, and keep everything after it. There could be
    text or numbers after the WH.
    Every record in this field starts with WH and there are no spaces after the WH.

    Thank you so much for helping (especially on a Saturday !!)

    Michael Abrams

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Truncation (WIN 2000 Acc 97)

    Use : Mid([YourField],3)
    Francois

  3. #3
    4 Star Lounger
    Join Date
    Jun 2001
    Location
    Sacramento, California, USA
    Posts
    491
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Truncation (WIN 2000 Acc 97)

    Wow - I was about to go home from work, and decided to check the lounge first....

    Thank you so much Francois. I really, really appreciate your help.

    Michael

Posting Permissions

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