Find and replace unique records

[Guest]

I have a table with a field called "Status" whose values are Active and
Cancelled. The default value for this field is Active. I have found that
several hundred records need to be changed to Cancelled. Is there a way I can
use an update query to search for records by the Account Number field, unique
to each record, and change the value in the "Status" field to Cancelled. The
update query example that I have seen search using only one value.

Thanks.

 

[UpRider]

Add a temporary field to the table. Call it xflag. Scroll thru the table
and put an X in xflag for each record that you want changed. Have your
update query look at xflag to determine which records to change. Make a
copy of your table first, just in case. Cumbersome but workable. When all
is OK, you can delete xflag in design mode.

If you need to get a wider view of the records than you can get in the table
view, you can use the form wizard to create a temporary form and update
xflag there.

UpRider