Mass update or append

[rizzir]

Hi,
can any help : )
i am trying to mass update one field in a table.
Basically i have created a new check box (Yes/No Value) in my customers table.
Basically i will tick this box if a customers placed any order with our company.

At present all our existing customers have placed orders with us. and i want to add value Yes to this field.

What method can i use to make this Mass update all customers records.

thanks in advance

 

[MStef]

Try with UPDATE query.

 

[Krava]

Hi, rizzir!

You can use Update query. Select your table for the query, then you choose the field you want to update and then, into "Update into" box you enter the value, means "Yes".

Krava