Microsoft Office Tutorials and References
In Depth Information
Updating a column based on an expression
Update a column based on an
4 Add the fields to be updated.
5 Copy the expressions to the Update To line (removing any field title,
such as FN:), and delete the old calculated columns.
6 Click Run.
TIP You should not be concerned when creating an update
query that the final layout on the query grid looks significantly
different to the original select query. The idea is to start with a select
query to easily identify how calculations should be constructed, and
then you remove the calculated columns using copy and paste for the
expressions to transfer the calculation into the update to area on the
grid below the appropriate fields to be updated (remembering to
remove any labels such as FN:).