Tick all Boxes

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

News - 15 Jun 2007 04:51 GMT

I have a database that I have imported from other sources. One of the
columns I have created has a data type Yes/No with a tick box (I am in
datasheet view of a table). Is there an easy way to tick every box other
then ticking on each individual one. (I have 2418 records)

Thanks

Signature

Dan Field
(Surveyor)

Reply to this Message

Allen Browne - 15 Jun 2007 05:50 GMT

Use an Update row to set the yes/no field to Yes for all records:

1. Create a query using this table.

2. Change it to an Update query (Update on Query menu.)
Access adds an Update row to the grid.

3. Drag the yes/no field into the grid.
In the Update row under this field, enter:
True

4. Run the query.

Signature

Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

>I have a database that I have imported from other sources. One of the
> columns I have created has a data type Yes/No with a tick box (I am in
> datasheet view of a table). Is there an easy way to tick every box other
> then ticking on each individual one. (I have 2418 records)
>
> Thanks

Reply to this Message