When I execute an update query, it prompts me to provide a parameter value, in this example memnum, and should update the entire column of the code field, which is a one-digit field, according to the query.Beginning memnum updates only one row, not the entire column, when I insert it. How to join and update two tables in order to alter every value in the code field.