So I currently use an Append Query to copy certain fields data from one table to another.
Then an update query is run to change two fields data from Planned to Ongoing.
This works well for us if this is the first time it is being run.
I know an append query adds records to a table. An Update query updates records in table and delete, well deletes records in a Table.
How do I get them all to work together? Append records from Table1 to Table2 that don't exists in Table2. Update records in Table2 if the records exists and delete a record from Table2 if they meet certain criteria.
It seems simple enough using the ID of the record that matches in both Table one and two.
Does this make sense or is there an easier way?