How to change one field in all records simultaneously?

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.

Use an update query! :-)

--

The 11th day of every month:

http://truthaction.org/forum/index.php


"Reecio85" wrote:

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" wrote in message
...
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 [table] 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