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_teat