An integrated Append + Update query ?!

[cement]

Hi,

i have a linked table in my DB, and i have created Append and Update queries for both inserting new records , and for updating existing ones.

but since there are many linked tables in my DB, i am realizing this way of doing this to be a pain, really.

my question is that is it possible and how can i do both the Append and Update actions in just one query or something like that , so that i don't have to create an Append query for each table, and then redo the steps for another update query and have to run the two queries for each table when i have some new (and updated) records to be written to my tables.

thanks in advance for your help.

[weekend00]

you can't do append and update by one query.

are you to update the same table which you just append to? in this case ,it's possible to do both in one append query(only append, not append and update).

if it's not possible to combine the 2 queries into 1, you can create macro or module to do it.

[cement]

yes, i both have new records and modified records, so i am doing that on the same table.

how can i tell it to append the new records and check and if there is some records with same IDs as on the target table, then do the update procedure for them ?

i still don't get how can i do.
can you also please explain a bit more about the macro or module approach you talked about ?

Thanks

[weekend00]

macro or module is something like that you can run a list of actions. e.g
run query1
run query2
etc.
...

you may look at a textbook or search on internet for more details.