Del query using criteria from another table (1 Viewer)

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

Perhaps: create a select query that identifies the relevant records on the main table. Create a delete query based on the history table and the first query.

Or perhaps: make the second query an update query so you don't have to delete and recreate.

Or perhaps: Delete the whole of the history table and recreate it afresh.

All depends on what exactly you want to do

Tks Neil.
Probably yr first suggestion is best.
I dont think I made it totally clear.
The main table has only 1 set of "code" reference data.
The append table has multiple code data,ie a copy of evrything that has been lookd at in the main table.
So deletes from append are only partial,when the main has been changed in some way and needs to be saved
However the difficulty with that is I am having a problem doing a delete query where it refers to a criteria in another table/query.It keeps asking me to define the Delete table.....and thats the part I cant get past

Try this query (type in the SQL View of a new query, using the correct table names, field names, and criteria):-

DELETE *
FROM [append table]
WHERE

Jon K
Many Thanks.
That works brilliantly

Regards
Captnk