Hi Perry,
you can use an Update query to update the desired records. Go to the
Query tab and click on New/Design. In the design window select your
desired table. In the Menu bar at the top of the Query Design Window
(the first Menu Bar that contains File, Edit, View,...) , go to the
Query menu and select "Update Query". Now go back to your table in the
Query Design view, scroll to your field that you want to update and
double click that field. This will place the field name in the "Field"
cell in the grid below. This is the field you want to update. In the
"Update To" cell enter the value you want to update the field to. For
Yes/No fields just enter True for yes and False for No. Then, in the
"Criteria:" cell below that you need to enter the criteria for the query
to use so that you update only the desired rows. If you want to update
all the rows to the same value, just leave Criteria blank. But if you
want to update only specific rows, then enter something like
yourTableName.S omeField = 'something"
Criteria: ExcelTable.Firs tName = 'Joe'
This tells the query to only update your Yes/No field to True for rows
where the FirstName = 'Joe'. Note that I delimit the text 'Joe' with
single quotes. You have to delimit Text with single quotes. Numeric
values do not require delimiting. Date values in Access are delimited
by the # Pound symbol.
HTH
Rich
*** Sent via Developersdex
http://www.developersdex.com ***