I have a table to which I append data,(as a quick restore feature,to save redoing calcs from the main table).
However if I alter the main table I may want to resave the changes,but an append query doesnt replace existing data.
SO i need to set up a Delete query that will delete data from the append table,that fits a criteria from the main table,(which I call
However if I alter the main table I may want to resave the changes,but an append query doesnt replace existing data.
SO i need to set up a Delete query that will delete data from the append table,that fits a criteria from the main table,(which I call
Code:
,comprising [date&location]
Whilst a select query will find the relevant data,with the main,and append tables in the query,It will not let me run it as aDel query and keeps asking for the table to be deleted to be specified.
However I have tried heaps combinations and nothing works.
Any suggestions as to how I can set up the del query using the "code" field from the main table to delete the same code in the append table please
Captnk