Update query: Difference between revisions
Jump to navigation
Jump to search
TOstryzniuk (talk | contribs) m (m) |
TOstryzniuk (talk | contribs) m (minor) |
||
Line 7: | Line 7: | ||
There are two parts in the process: | 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]] | *Open [[CFE]] | ||
*in the tool bar select the following: | *in the tool bar select the following: | ||
Line 17: | Line 17: | ||
**Close the table box | **Close the table box | ||
**Scroll down and find '''R_dc_treat'''. | **Scroll down and find '''R_dc_treat'''. | ||
**Double click on | **Double click on '''R_dc_treat'''TWICE | ||
**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'' ''' | |||
Revision as of 15:03, 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_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