update all records in table based on criteria

D

dfeigen115

I have a field in table that periodically needs to be reset to one of two
values based on external events. The criteria that will drive the update
values is stored 2 existing fields in the table.

What I haven't been able to construct is the code to read, analyze, and if
needed update all the rows in the table. COuld someone provide a sample of
what the code should look like.

Thanks in advance...
Dan
 
K

Klatuu

Create a regular Update query that includes the fields to be updated an a
reference to the source data to update you current data. Then you can create
a calculated field in the query that returns True or False depending on
whether it should be updated. Set the criteria for the calculated field to
True.
 
Top