Is there an easy way to change all or selected records in a table

[dhstein]

I have a database that I occasionally will want to change one field in all
records in a table to the same value.

Question 1: Is there a direct way to do this ?

Assuming the answer to Q1 is "No" then I could write a simple routine to
ask for table name, field name and value and then update all records. This
would be a generic routine that I could run against any table and any field.

Question 2:
But if I wanted to be selective about which records, then I'm not sure if I
could run an update against a query (instead of against the table). I'm
trying to make this process as simple as possible. I hope this request is
clear and any advice or information is appreciated.

 

[Douglas J. Steele]

Use an Update query:

UPDATE MyTable
SET MyField = "NewValue"

You can be selective by adding a WHERE clause:

UPDATE MyTable
SET MyField = "NewValue"
WHERE Field1 = 123

 

[dhstein]

Thanks Doug - I'll give it a shot.

Use an Update query:

UPDATE MyTable
SET MyField = "NewValue"

You can be selective by adding a WHERE clause:

UPDATE MyTable
SET MyField = "NewValue"
WHERE Field1 = 123