Update Query for Multiple Values in Single Field

[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

 

[Guest]

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.

 

[Guest]

perfect! Thank you

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.

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