Updating data in a table

[Guest]

I have several thousand SKU's that change up to a new SKU.
Example Sku 12345 changes up to SKU 98765. My problem, is that I have an
on-hand quantity of SKU 12345 but all pricing got cahnge when I ipmorted a
new price list into the table from the supplier. Since they don t use SKU
12345 any longer to cost and reatil are set to $0.00. I would like to move my
onhand inventory to the new SKU and replace the old SKU onhand inventory with
0.

The end would look like this
old SKU Onhand QTY
NEW SKU On ha
Now 12345 5
98765 0
update to new 12345 0
98765 5

all of the new SKU's are currnetly in the table and the description field
contains the new SKU formated like this " USE 98765" no quotations
anu ideas what qurery may do this for me or any suggestions

 

[[MVP] S.Clark]

Updating records with SQL is done with an Update Query.

e.g.
Update tablename Set fieldname = "Value" Where ...

FWIW:
Mid$("USE 12345", 4) = "12345"

--
Steve Clark, Access MVP
FMS, Inc.
Call us for all of your Access Development Needs!
1-888-220-6234
(e-mail address removed)
www.fmsinc.com/consulting