Chang of code

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Ramesh - 14 May 2007 15:49 GMT

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

Reply to this Message

Al Campagna - 14 May 2007 16:04 GMT

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.

Signature

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."

> HI,
>
[quoted text clipped - 7 lines]
>
> Ramesh

Reply to this Message

scubadiver - 14 May 2007 16:07 GMT

Use an update query :-)

> HI,
>
[quoted text clipped - 9 lines]
>
> Ramesh

Reply to this Message

scubadiver - 14 May 2007 16:10 GMT

Ignore my previous message!

Why have two different fields?

> HI,
>
[quoted text clipped - 9 lines]
>
> Ramesh

Reply to this Message