Update Query Using Yes/No

J

Jesica

I'm updating an existing database. I just added multiple checkbox fields
(Yes/No). All the existing records have defaulted to No (or unchecked). How
can I make them all Yes (checked)? I know I have to create an Update Query
with a set value to True, but I don't know how to....can someone walk me
through it please and thank you?????????
 
D

Dirk Goldgar

Jesica said:
I'm updating an existing database. I just added multiple checkbox
fields (Yes/No). All the existing records have defaulted to No (or
unchecked). How can I make them all Yes (checked)? I know I have to
create an Update Query with a set value to True, but I don't know how
to....can someone walk me through it please and thank you?????????
Click to expand...

Working in the database window, create a new query in design view based
on your table. Drag the fields you want to update from the table
representation in the upper pane of the design window to the field grid
in the lower pane. Click the dop-down arrow next to the Query Type
button on the toolbar, or click menu item Query, and select "Update
Query" from the list/menu. Now, in the field grid, on the "Update To:"
line, underneath each of the yes/no fields you placed in the grid, type
in "True" -- without the quotes.

Now click the Run button (or menu item Query -> Run). Unless you made a
mistake, your query should run and update the table.
 
J

Jesica

Excellent! Thanks Dirk you just saved my butt!

Dirk Goldgar said:
Working in the database window, create a new query in design view based
on your table. Drag the fields you want to update from the table
representation in the upper pane of the design window to the field grid
in the lower pane. Click the dop-down arrow next to the Query Type
button on the toolbar, or click menu item Query, and select "Update
Query" from the list/menu. Now, in the field grid, on the "Update To:"
line, underneath each of the yes/no fields you placed in the grid, type
in "True" -- without the quotes.

Now click the Run button (or menu item Query -> Run). Unless you made a
mistake, your query should run and update the table.

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)
Click to expand...
 
Top