This immediately brings up the message window, letting you know about the changes that are going to be made.If you click on the Show Help button you will reveal the following text. Unlike most queries that display data in Datasheet view, an update query updates one or more fields in a specific table in a single operation.The Table row shows the name of the table that contains the field.To see how the values will be changed, look at the expression in the Update To row.Microsoft Access offers a variety of options for making updates to records.Updating the data from a query in MS Access (MDB) may not always be possible. I assume that the problem is to format it somehow, but I don't know how.
Using the procedure discussed in the tutorial, a Test Product Qry was created using the following SQL View of the Make Table query.
Future articles will consider cases where more than one table may be involved.
This article uses a table created out of choosing only a few columns from a table in the Northwind database to keep the discussion simple without compromising the concept.
This is especially true if there are two or more tables involved in the update process.
In general data may be updatable, updatable under certain conditions, or not updatable at all.