Update query: Difference between revisions
Jump to navigation
Jump to search
TOstryzniuk (talk | contribs) m (Bulk update query - step) |
TOstryzniuk (talk | contribs) m (m) |
||
Line 1: | Line 1: | ||
This article explains how to write a bulk update query using Access in centralized front end ([[CFE]]). | 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 steps below use one example to demonstrate how to replace a specific item in a data field with another. |
Revision as of 14:57, 2015 January 9
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