Question How to update records with criteria

[RiderOfTheli]

Hello,

I've got database, with few table, queries and forms. The aim of the database is to send letters to the Vendors. First, I upload data into Access tables from our system, but there are few additional infomations on the letter, which are not in the main data (for example Posted, Blocked, Paid). What I'm trying to do is to set criteria, or condition for those fields. for example IIf [Clearing_Date] = "", "No","Yes" and it is for field [Paid] (when in Clearing_Date field is something, in Paid field appears "Yes") but it doesnt working...I have put this as event, default value, control source...it's not working..the values are all the same for each record...

So the question is, how to update table records (additional fields with this type of conditions for each) or where to put expression - that for each record values are correct??

Thank you in advance

 

[John Big Booty]

Try first creating a select query that selects the records you wish to update by your criteria. Once you are happy that, that query is working as you wish, convert it to an update query and add the Update To details.