ticking 1000 checkboxes in one step?

  • Thread starter Thread starter Nathon Jones
  • Start date Start date
N

Nathon Jones

Hi,

I've just added a Yes/No field to an existing table of 1000 records.

I want them all to be checked.

How can I do this in one step rather than having to go through every record
and placing a tick?

Thanks.
Nath.
 
nath,

Start making a new query in design view; add the table, and drag the
Yes/No field down to the grid. From the menu, change it to an Update
query (Query > Update); notice th new line headed "Update To:" that
appears in the grid; in it, type Yes under the particular field, and run
the query (Query > Run). The job is done.

HTH,
Nikos
 
Thank you Nikos,

Worked out great.
Nath.

Nikos Yannacopoulos said:
nath,

Start making a new query in design view; add the table, and drag the
Yes/No field down to the grid. From the menu, change it to an Update query
(Query > Update); notice th new line headed "Update To:" that appears in
the grid; in it, type Yes under the particular field, and run the query
(Query > Run). The job is done.

HTH,
Nikos
Click to expand...
 
Back
Top