Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Changing data in a table

Discussion in 'Information Technology' started by Chris, Nov 12, 2005.

  1. Chris

    Chris
    Expand Collapse
    Guest

    I am trying to figure out how to change the data in one field. I would like
    to remove a three letter prefix that accompanies my part number. There are a
    couple thousand entries so I am looking for the easiest way possible. Any
    Ideas??

    Thank you
     
  2. Loading...

    Similar Threads Forum Date
    S Asia Thinking about the big move: The Sikh way of life changing in Khyber-Pakhtunkhwa Breaking News Mar 22, 2014
    Opinion Haanji's Quick Takes on a Changing World (September 23, 2013) Breaking News Sep 22, 2013
    Changing my last name to Kaur... Questions and Answers May 15, 2013
    Life-changing Inspirational Stories Mar 31, 2013
    USA Sikhism and the Changing Electoral Demographic Breaking News Mar 8, 2013

  3. John Vinson

    John Vinson
    Expand Collapse
    Guest

    On Fri, 11 Nov 2005 10:59:04 -0800, "Chris"
    <Chris@discussions.microsoft.com> wrote:

    >I am trying to figure out how to change the data in one field. I would like
    >to remove a three letter prefix that accompanies my part number. There are a
    >couple thousand entries so I am looking for the easiest way possible. Any
    >Ideas??
    >
    >Thank you


    An Update query would do the job. You don't say if you want to do this
    globally for all records, but if so: BACK UP YOUR DATABASE (just in
    case you make a mistake, or I do so in my advice), and run an Update
    query updating the field PartNo (use your own fieldname of course) to

    Mid([PartNo], 4)

    This function will return the substring of the field starting at the
    fourth byte and update the table to that substring; that is you'll go
    from

    ABD1234
    ADD1512
    XYZ3431

    to

    1234
    1512
    3431

    John W. Vinson[MVP]
     
  4. Chris

    Chris
    Expand Collapse
    Guest

    Thank a lot!
     

Share This Page