update 3 fields

[Nasdawg]

Hello all,

I have two tables on table contain info in the following manner

Name
1234p01
5678p02
1234p03

The next table hase thre columns
p01
p02
p03

I would like to do a query so that the corresponding p0x goes into the proper columns. I am using access 2k to do this.

Thanks in advance

 

[M8KWR]

i would create 3 update queries 1 for each column.