You can use an update query to update the values in one table with the values from another table. You can join the two tables on some common field or combination of fields. When you need to update data from one table to another the data types for the source and destination fields must either match or be compatible. When you update data from one table to another and use compatible 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.

свернуть