Update Query -Acting on only changed records

[AMBER]

Good morning!

I want to be able to create an update query in our fleet
database that updates address information for our drivers.
I will have a drivers table and current employee
information table. I want to only update those drivers
who have changed addresses. Is this possible with an
update query?

Thanks, in advance,
Amber

 

[John Vinson]

Good morning!

I want to be able to create an update query in our fleet
database that updates address information for our drivers.
I will have a drivers table and current employee
information table. I want to only update those drivers
who have changed addresses. Is this possible with an
update query?

Sure, if there is some way using the information in the table to
detect which addresses have changed. Which table are you trying to
update? Which table will have the correct address?

Basically you would need a criterion on the table being updated of

<> [othertable].[Address]

to limit the update to those records with mismatched addresses.