Update Query Same Field Multiple Criteria

[jkpats12]

Hello,

Was wondering if there is a way without building individual update queries, to update info in one field that has multiple criteria ?

Basically I need to change/update daily multiple ID numbers to new ID numbers, long story on why this needs to be done but for now I need to do it this way.

Example: 12345 update to ABCDE, 6789 update to FGHI, etc. These ID's are all within the same field in the table.

It works fine running each ID one at a time but was wondering if it is possible to do all these updates within one query or code ?

Thanks for any assistance

 

[KeithG]

You could create a VBA function to create the string from the orignal ID and update the column. Then use this function in your query. If you post an example db I could create an example for you.

 

[jkpats12]

Thanks Keith, I attached a scaled down copy......the ID field within the table contains multiple ID's that I want to change each to another unique ID number.

Again thanks

 

[KeithG]

What letter is 0 equal to?

 

[KeithG]

Here is an example. In the example I have 0=?

 

[jkpats12]

Thanks Keith, I'll try it out and let you know how it goes.

 

[KeithG]

Use the function I made in a update query if you want to update the ID's.