|
|
|
#1
03-17-2006, 07:05 AM
|
|||
|
|||
Selecting and modifying records in a table
I would like to write an update query to a table. I wish to select all records in the table that have an ID in a range that I can specify and then populate a new field with a common value for all records selected.
Any hints please to a novice. 
|
|
#2
03-17-2006, 09:04 AM
|
|||
|
|||
|
Use an Update query.
Start a new query, add your table and then right click in the header area and choose "Update Query" Put in your criteria for the ID field and then the value for the field to update in the "Update to" row.
__________________
John F
|
|
| Bookmarks |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Problem creating new records using old values on same table. | gailoni | Programming | 0 | 10-22-2008 10:08 PM |
| Problem Selecting Records for a Report | Joe | Programming | 0 | 09-27-2008 12:27 PM |
| Delete all records in a table? | bob646 | Access | 1 | 05-20-2007 09:41 PM |
| Inserting multiple records into a table | New2Access | Programming | 0 | 02-18-2007 09:46 PM |
| Creating a string from all records in a table | ocordero | Programming | 2 | 08-07-2006 07:21 AM |
Linear Mode
