I want to run a query that updates a record I a table if the record already exists. But if the record does not exist I want it to create a new record in the table.
The source table is "Source". The destination table is "Destination"
The both have a key field named "RecordID"
If I just try to run an update query it fails because the record isn't there. But if I run an append query it works fine if the record is already there.