I want to run an append query to move records to another table. IF that is successfull I want it to then run a delete query to remove those records from the first table.
I dont need any super complex error checking, just a check that i appended X number of records and that I am about to delete the same X number of records.
I have created the append and delete queries and they are using criteria from a form element to select the records.
Do I need to run some kind of count and set a variable equal to that and then check it?