Appending or Updating data query

[newbieaccess]

Hi all - I'm working on an access db that contains 3 tables
1) Member Table
2) Address Table
3) Contracts Table

Then I have a form that pulls them all in together with subforms as the Address & Contracts attached to the Member

Each week someone goes out to another source and pulls in new information into Excel which we can add to our db from their 3 new tables

The problem is that some of the data could already be in the db so I can't really do an append. I've put the new data that was just generated into temp tables with the same names and now I'm not sure what my next steps are to automate this so that it can update or replace the old Members data with the most recent but append data that is completely new?

Any ideas? thoughts? Help please

Thank you

 

[statsman]

My first thought would be to do both. Run a macro which first runs the update query, then runs the append query.

Set up conditions in your queries whereby:
If the member already exists the data will be updated.
If the member does not exist, the data will be appended.

 

[newbieaccess]

Thank you for your help

Question how do I say in the query update if there's already a member. Would I do I join on the new temp table with the master table?

So I would have 6 total queries? 3 update and 3 append then I put in 1 macro?

Thanks again