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