Sep 28, 2006 #1 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
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
Sep 28, 2006 Thread starter #2 abbottboi IS-IT--Management Nov 14, 2005 94 CA maybe have a default value of yes? how do i do that? lol.. sorry not an expert in access Upvote 0 Downvote
Sep 28, 2006 1 #3 PHV MIS Nov 8, 2002 53,708 FR 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 Upvote 0 Downvote
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
Sep 28, 2006 1 #4 Golom Programmer Sep 1, 2003 5,595 CA Run Code: UPDATE myTable SET YNField = TRUE Click on the [red]![/red] icon after building this Update Query. Upvote 0 Downvote
Run Code: UPDATE myTable SET YNField = TRUE Click on the [red]![/red] icon after building this Update Query.
Sep 28, 2006 Thread starter #5 abbottboi IS-IT--Management Nov 14, 2005 94 CA Thanks! worked like a charm! Upvote 0 Downvote