I am trying to keep an up to date list of bands that are playing at a festival. One table ('Existing') contains a list of the 'BandName' 'Confirmed' and 'DateConfirmed'. The other ('New_Bands') is a list that comes from a website and contains a new 'BandName' field.



What I want to do is to compare the two tables. If a record exists in the 'Existing' table with a bandname that does not exist in the 'New_Bands' table, I want to copy the contents of that record to a table called 'Dump' and remove it from the 'Existing' table. If a band exists in the 'New_Bands' table but not in the 'Existing', I want to copy that to a new record in the 'Existing' table, updating only the 'BandName' Field.

Can Access do this? I have been trying Queries, but I can only get it to update the query, not really what I want. I want the tables themselves to be updated with the data from the other tables