>Sorry, I meant without the SCAN. Say you were in Access or in the Command Window, could you accomplish this in a single UPDATE command. I can only guess that the answer in no.
>
>Brenda
Brenda,
I wouldn't say no but rather I don't know yet (not sure of the syntax it might be supported).
For Access I have no idea about the SQL it supports. If it's as SQL server then would be possible. Off the top of my head :
update codes set code_name = ;
(select code_new from codes c, codes_conv cc where c.code_name == cc.code_old) ;
where code in ;
(select code_old from codes_conv)
PS: Just after posting I've great feeling it doesn't look right.
Update < bg > SQL server - Access might support this :
update codes set code_name =
(select code_new from codes_conv
where codes.code_name = codes_conv.code_old)
Cetin