Check all boxes as yes! 2

[abbottboi]

Hi,

I have a table of 2000 records and i have a yes/no box for each of them.

I want to check all of the boxes as Yes but don't want to go through them all.

Any ideas?

Thanks

 

[abbottboi]

maybe have a default value of yes?

how do i do that? lol.. sorry not an expert in access

 

[PHV]

I want to check all of the boxes as Yes
Use an update query (SQL code):
UPDATE yourTable SET yourField=True

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[Golom]

Run

UPDATE myTable SET YNField = TRUE

Click on the [red]![/red] icon after building this Update Query.

 

[abbottboi]

Thanks! worked like a charm!