Chang of code

[Ramesh]

HI,

I have a Product table with fields Oldcode and Newcode. Now I need to
replace the ProductCodes in the Order table, the old Codes with the
corresponding New codes.

How can i do this other than tediously using Find & replace? Is there a way
i could create some Update query to pick up from the Product table and
replace?

Thanks for any help.

Ramesh

 

[Al Campagna]

Ramesh,
It would have been helpful had you provided a bit of detail about your
table structure, and some sample data...
(what you have now vs. what you'd like to see)

If your data is similar to this...
Old New
123 798
124 841
642 167
and you want...
Old New
798 798
841 841
167 167
then an Update query that takes the value from New and replaces the Old value will do it.

--
hth
Al Campagna . Candia Computer Consulting . Candia, NH USA
Microsoft Access MVP
http://home.comcast.net/~cccsolutions

"Find a job that you love, and you'll never work a day in your life."

 

[Guest]

Use an update query

 

[Guest]

Ignore my previous message!

Why have two different fields?