Update query: Difference between revisions

Line 1:

Also referred to as a query type - APPEND

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

Line 5:

Line 7:

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".

Steps broken down into 4 parts

~~There are two parts in the process:~~

==Part 1==

Set up ~~the~~ selection query ~~first~~

Set up a selection query

*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]]

Line 25:

Line 27:

**Go back to DESIGN VIEW. Make any changes if needed.

==Part 2==

~~You will now do the final steps to change~~ this from a ~~selection query~~ to and Append query that will actually make the change you set up.

Change this from a Selection Query to and Append query

that will actually make the change you set up.

**Go to TAB: Query Tools - Design

**Select and SAVE as : Query Type - '''APPEND'''

***~~you will~~ notice that the symbol beside the query you named will be different.

***notice that the symbol beside the query you named will be different.

**~~you will also~~ notice that the row that was labelled sort has not changed to: Update TO.

**notice that the row that was labelled sort has not changed to: '''Update to'''.

==~~Final steps~~==

==Part 3==

in the first column in the Update to field, type in: "DC"

*in the first column in the '''Update to''' field, type in: "DC"

*in the second column, first row, remove ~~from the field~~ NewValue: "DC"

*in the second column, first row called Field, remove NewValue: "DC"

*~~Save~~ again as a APPEND - query type.

*SAVE again as a APPEND - query type.

==Ready change data==

==Part 4-Ready to change data==

Press the red ! run button.

*query has done it job.

@@ Line 1: / Line 1: @@
+Also referred to as a query type - APPEND
 This article explains how to write a bulk update query to a data field using Access in centralized front end ([[CFE]]).
@@ Line 5: / Line 7: @@
 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".
+Steps broken down into 4 parts
-There are two parts in the process:
 ==Part 1==
-Set up the selection query first
+Set up a selection query
 *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]]
@@ Line 25: / Line 27: @@
 **Go back to DESIGN VIEW. Make any changes if needed.
 ==Part 2==
-You will now do the final steps to change this from a selection query to and Append query that will actually make the change you set up.
+Change this from a Selection Query to and Append query
+ that will actually make the change you set up.
 **Go to TAB: Query Tools - Design
 **Select and SAVE as : Query Type - '''APPEND'''
-***you will notice that the symbol beside the query you named will be different.
+***notice that the symbol beside the query you named will be different.
-**you will also notice that the row that was labelled sort has not changed to: Update TO.
+**notice that the row that was labelled sort has not changed to: '''Update to'''.
-==Final steps==
+==Part 3==
-in the first column in the Update to field, type in: "DC"
+*in the first column in the '''Update to''' field, type in: "DC"
-*in the second column, first row, remove from the field NewValue: "DC"
+*in the second column, first row called Field, remove NewValue: "DC"
-*Save again as a APPEND - query type.
+*SAVE again as a APPEND - query type.
-==Ready change data==
+==Part 4-Ready to change data==
 Press the red ! run button.
 *query has done it job.