I have these 2 tables of the identical structures: current_removals, faxnumbers
and would like to create an update query that would accomplish the following:
update the faxnumbers.Remove field to the value "True" for every value that is equal by these 2 fields: current_removals.SoldToFax and faxnumbers.SoldToFax
What Access steps are to be taken to accomplish this or what SQL query should be written?
and would like to create an update query that would accomplish the following:
update the faxnumbers.Remove field to the value "True" for every value that is equal by these 2 fields: current_removals.SoldToFax and faxnumbers.SoldToFax
What Access steps are to be taken to accomplish this or what SQL query should be written?