Update query: Difference between revisions
TOstryzniuk (talk | contribs) m TOstryzniuk moved page Append query to Update query: Update query not append query |
TOstryzniuk (talk | contribs) m clean up |
||
| Line 1: | Line 1: | ||
This article explains how to write a bulk update query to a data field 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]]). | ||
| Line 28: | Line 26: | ||
==Part 2== | ==Part 2== | ||
Change this from a Selection Query to and ''' | 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 | **Go to TAB at top of screen: Query Tools - Design | ||
**Select and SAVE as : Query Type - '''APPEND''' | **Select and SAVE as : Query Type - '''APPEND''' | ||