Update vs Append

[Rin]

I have an external table "NewData" from which I need to add missing data and update existing data in an internal table, tblAgents. If I create an Update Query I know it will update the existing record data in tblAgents, but will it add records that are missing? Do I need to create an Append Query to run first?

I know this is a pretty elementary question - I'm just getting started in Access.

Thanks,

~Rin

[June7]

Could run INSERT and UPDATE actions.

However, might be able to accomplish both in a single UPDATE query. Often referred to as UPSERT. Review https://stackoverflow.com/questions/...g-in-ms-access

[isladogs]

A standard UPDATE will just update existing records but will not add new records.
So the normal solution is an UNMATCHED APPEND query followed by an UPDATE.

However as June said it is sometimes possible to combine these using an UPSERT (aka UPEND) query which has a left join between your two tables.
Here's another explanation on my website with some examples which may be helpful http://www.mendipdatasystems.co.uk/u...ery/4594428616
If you understand how it works, then it may save you time.

[orange]

Rin,

In addition to the advice offered by June and Colin, here are a few questions to help with the logic of the process. If "NewData" records could consist of multiple (more than 1) records/transaction for a given record in tblAgents or within "NewData" itself, then the sequencing of "updating or inserting" could be critical to your situation.
This may be obvious, but for clarity, if the "NewData" is related to Dates (hireDate, changeDate...) then you'll have to ensure the changes respect this.
Good luck.