How to change one field in all records simultaneously?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have an existing table of customers; names, addresses, etc.

I've just added a yes/no check box field and titled it "mailing list" so
that I can easily remove people who request to be removed. However, the
default value is No, and I can't find a way of changing all the records to
read 'Yes' in this field.
 
Reecio85 said:
I have an existing table of customers; names, addresses, etc.

I've just added a yes/no check box field and titled it "mailing list" so
that I can easily remove people who request to be removed. However, the
default value is No, and I can't find a way of changing all the records to
read 'Yes' in this field.
Click to expand...

UPDATE
SET [mailing list] = TRUE;

You might also want to change the default value of the field to be True, so
that new records will automatically be set to True.

Carl Rapson
 
Back
Top