How to UPDATE multiple values for a multivalued field?

[lookingforK]

Hi,

I am using MS Access 2007.

I would like to use UPDATE query to update the values in a multivalued field.

For example, in the multivalued field, some values should be changed like:
"1" to "Mike"


"2" to "Jane"
"3" to "Tom"
...
"10" to "Ada"

How can I write the query?

Can I use the UPDATE query to change these values at the same time?


Thank you in advance.

[June7]

Google: Access query update multi-value field
Review http://stackoverflow.com/questions/6...018502#6018502

[lookingforK]

Thank you Jane7.

I have read the reference.

It is only for 1 value update one time.

For my case, I think there should be a SQL syntax like including IF, CASE, SWITCH , or ... to do the update.

But how to?

[robert0123]

Boy, for a one time deal, depending on the number of records. Id make a spreadsheet or table of the "key" (i.e. column with old value and column with new value) and then just link to the old value and "update" to the new value with a simple update query. Dont get me wrong, I love creating SQL statements, but for a one time shot...eah...not so much.

[orange]

Is there a reason for using a multivalued field? Many people consider these an "abomination". If you can go to a simple table with this data, you may save yourself a lot of headaches and time.

[June7]

I don't use multi-value fields because of the headaches they cause.

What you want might require VBA code.

Refer to links in your other thread https://www.accessforums.net/access/...eld-32544.html