Changing data in a table

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

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
 
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
Click to expand...

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