Update Query -Acting on only changed records

  • Thread starter Thread starter AMBER
  • Start date Start date
A

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
 
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?
Click to expand...

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.
 
Back
Top