Results 1 to 4 of 4
  1. #1
    gped
    Guest

    Extracting Specific Data

    I have a table with a field containing both text and numeric values. The data consists of a prefix consisting of 4 alpha and followed by 7 numeric (e.g. TRXU1234567)for a total of 11. Through a query, I would like to extract the first 10 letters/numbers leaving the last one off. Can someone help with the expression needed to be written in the criteria field. Thanks in advance!

  2. #2
    Mike B
    Guest

    Re: Extracting Specific Data

    make a new column in your query:
    ShortenedField: Left([Field],10) you may have to consider null values HTH

  3. #3
    gped
    Guest

    Re: Extracting Specific Data

    Mike,
    Thanks but I tried this and out of 1300 records only 267 pulled up. Should a new column be created with the expression you gave inserted or should I put this expression in the criteria box under the field where the data is pulling from. Thanks again for replying so fast!

  4. #4
    Mike B
    Guest

    Re: Extracting Specific Data

    in a new field...

Posting Permissions

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