Update question

[twinupshot]

I have a table with a field that has two Part numbers in the field- one being listed in () Parenthesis. example 56B900-09 (2221-9).
I need to keep the Part Number in Parenthesis and delete the other in this field. What is the best way of doing this? Update query?

Thanks,

Bryan

 

[gromit]

Step 1 - Make a backup!!

Yes, I would think that an update query would work. I would first try to do a practice query to see if you can successfully convert the part numbers. E.g. make a query with OldPartNumber and a NewPartNumber field and verify that they all convert as you expect.

If the part numbers are very consistent you might be able to use the RIGHT string function and just take the same number of characters off one end. Otherwise you might have to use InStr to location the first ( character.

Probably there will be a few records that may need some manual attention.

hth,

- g