How to change one field in all records simultaneously?

[Reecio85]

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.

 

[scubadiver]

Use an update query!

 

[Carl Rapson]

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.

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