I have a Access table with two fields. Field 1 is named activity code, Field two is named procedure code. Data in field one is in the format of 90801h, 90802h, 90803h. Data in Field 2 is in the format of Z123, Z124, Z125. In this example, 90801h is = to Z123, 90802h = Z124, & 90803h = Z125. However the 90801 #'s have no relevance as to what I am trying to accomplish in the end
I want to make an Update query that will read the values in Field2 (the Z Numbers) and replace the H numbers with another value that is also equal and relevant to me. For instance: I would like for the query to read Z123 in field2 and then replace 90801h with 1420.
I am trying to write an expression in my Update query that goes something like this:
If field2 is = to Z123 then Field1 is = to 1520 and If field2 is = to Z124 then Field 1 = 1530 and so on. What is the correct syntax to do this?