I have an update query which I would like to run to update a value in a column for a particular set of records using the corresponding values from another table.
Currently in the "Update To" section of the update query (see attached), I am updating the value in the column, "Letter" with the corresponding value in the NSCPP_Students_Temp table. However, I would like to add an "N" before the value from the other table. So for instance, if the NSCPP_Students_Temp table record has the value "C", then I would like the value "NC" written to the column of NSCPP_Students. I tried using concatentation, i.e. "N" & [NSCPP_Students_Temp].Lett
er but it isn't working, i.e., it still writes the letter without the "N" in front.