I have here a test DB that I am using to work on my real DB.

I am trying to take the data in table 2 and append the update column to table 1. [column1], [column2], or [column3], based on what value is currently in control type table.

Control type can be 1, 2 or 3 and is set when the macro first runs.
(I don’t have the macro in this DB yet)

I tried writing a iif formula in the Append To: section but that didn’t work or I didn’t do it right.

Any thoughts or help would be great.

create 3 update queries, one for each control type.

That is what I am hopping to avoid because my real DB has 24 columns and I really don’t want 24 update queries.