Update query criteria only if text is different

[darthkiro]

Just a heads up, I am fairly new to using Access. I am using a linked table (xlsx) to make updates to a tracker table. One field (column) [MigrationStatus] already has text in the tracker table and I need it to update only if the text in the linked table is different. Can anyone advise what I would need entered for the Criteria?

[Gicu]

Try xlsx.MigrationStatus<>tblTracker.MigrationTracker

Cheers,

[Welshgasman]

Where table.migration status not = linkedtable.migrationStatus

You would also need to link on a common unique key between them.

[Micron]

I would probably just update the field with the value. If the existing field is different it will update. If not, it will stay the same.