Update query: Difference between revisions
TOstryzniuk (talk | contribs) m clean up |
Ttenbergen (talk | contribs) m Text replacement - "[[Category: " to "[[Category:" |
||
| (4 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
This article explains how to write a | Update queries make bulk changes to data based on a set of criteria. (Unlike Select queries that just show the data.) | ||
This article explains how to write a update query, e.g. in [[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. | ||
| Line 27: | Line 29: | ||
==Part 2== | ==Part 2== | ||
Change this from a Selection Query to and '''Update Query''' that will actually prepare you to make change you set up after you run it. See Picture [[Media:Update query Part 2.JPG | Setting up Update Query Part 2-4]] | Change this from a Selection Query to and '''Update Query''' that will actually prepare you to make change you set up after you run it. See Picture [[Media:Update query Part 2.JPG | Setting up Update Query Part 2-4]] | ||
*Go to TAB at top of screen: Query Tools - Design | |||
*Select and SAVE as : Query Type - '''APPEND''' | |||
***notice that the symbol beside the query you named will be different. | ***notice that the symbol beside the query you named will be different. | ||
***notice that the row that was labelled '''sort''' has now changed to: '''Update to'''. | ***notice that the row that was labelled '''sort''' has now changed to: '''Update to'''. | ||
| Line 57: | Line 59: | ||
[[Category: Data Processing]] | [[Category:Data Processing]] | ||
[[Category: MS Access Tips and Techniques]] | [[Category:MS Access Tips and Techniques]] | ||
[[Category: Query]] | [[Category:Query]] | ||