Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Check all boxes as yes! 2

Status
Not open for further replies.

abbottboi

IS-IT--Management
Nov 14, 2005
94
CA
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
 
maybe have a default value of yes?

how do i do that? lol.. sorry not an expert in access
 
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
 
Run
Code:
UPDATE myTable SET YNField = TRUE
Click on the [red]![/red] icon after building this Update Query.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top