Update query

This article explains how to write a bulk update query to a data field using Access in centralized front end (CFE).

The steps below use one example to demonstrate how to replace a specific item in a data field with another.

The example below:

• in the "R_dc_treat" field in "L_log", there are erroneous values of "-1" however, all of these values must be replace with the value "DC".

There are two parts in the process:

Part 1

Set up the selection query first

• this allows you to look if the update you're are planning is going to do what you need it to do before you actually proceed to part 2.
• Open CFE
• in the tool bar select the following:
  • CREATE
  • Select: Query Design. A list of tables will appear
  • Select: L_Log
  • Close the table box
  • Scroll down and find R_dc_treat.
  • Double click on R_dc_treatTWICE
  • You should see R_dc_treat in two columns in the FIELD box.
  • In the SECOND column, change to field name to the following: NewValue:DC