Update Query for Multiple Values in Single Field

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have different values in a single field that all need to update. For ex,
Field name is color, and all Maroons update to Red, all Aquas update to Blue,
etc. I would like to have all of these updates done within a single query.
Right now I have it in multiple queries strung together by a macro, but this
is cumbersome.

Thanks
 
Build a cross reference table with two fields - OldColor NewColor and
fill it with all of the combination to do your update.

Create your update query and add the cross reference table. For criteria
use [OldColor] and for Update To use [NewColor] and run.
 
perfect! Thank you

KARL DEWEY said:
Build a cross reference table with two fields - OldColor NewColor and
fill it with all of the combination to do your update.

Create your update query and add the cross reference table. For criteria
use [OldColor] and for Update To use [NewColor] and run.

kayabob said:
I have different values in a single field that all need to update. For ex,
Field name is color, and all Maroons update to Red, all Aquas update to Blue,
etc. I would like to have all of these updates done within a single query.
Right now I have it in multiple queries strung together by a macro, but this
is cumbersome.

Thanks
Click to expand...
Click to expand...
 
Back
Top