How do you update a column in a table with data from a query?
By including the query and the table together in an Update query, or changing
the query to an Update query.
For a more detailed answer please post a more detailed question, such as the
SQL view of the query in question and a description of what you want updated.