Updating multiple fields using update query
Furthermore, when you update data from one table to another and use compatible data types instead of matching data types, Access converts the data types of those fields in the destination table.As a result, some of the data in the destination fields may be truncated (deleted).This article describes how to create and run an update query in an Access desktop database.You use an update query when you have to update or change existing data in a set of records.The section Restrictions on data type conversions lists the ways in which you can and cannot convert data types.
How to back up your database When you need to update data from one table to another, consider the following rule: the data types for the source and destination fields must either match or be compatible.
The process of updating data from one table to another follows these broad steps: The steps in this section assume the use of two similar tables.
You cannot use an update query to add new records to a database, or to delete entire records from a database.
To add new records to a database you use an append query, and to delete whole records from a database you use a delete query.
Note: You cannot run an update query in a Web browser.
If you want to run an update query in an Access Web database, you must first open the database by using Access. If you are using an Access web app, you can use data macros to update or change existing data in a set of records.