update all records in table based on criteria

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Dcount (multiple criteria) 3
update all records 2
update time value issue 7
Need combo box to refresh when moving to new record 2017 1
populating one combo box based on another 2
Update Query based on Current Recordset 26
date lookup in tables 5
Setting field value if a value exists in another table 3

Back
Top