Changing data in a table

[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

 

[John Vinson]

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]

 

[Guest]

Thank a lot!