Append Query Problem, wont add entries

[JTQ911]

I am trying to add data to the same column which is in multiple tables at once by running a macro that has multiple queries. I run a macro, and the first is a delete macro, which deletes the column and then the next is an append query which then adds the new column wtih the new data....and it works, for adding it to one table. But when I try to do this for updating two tables from the one macro (using 4 queries, 2 add, 2 delete), I get the usual warning messages "you are about to add/delete 10 entries, and this is for the first table, so i just lclick "ok" "ok" and then i get the message "you are about to delete 10 entries" for the 2nd table, PROBLEM IS THEN I Get message "You are about to append 0 entries" IT SHOULD BE APPEND 10, its the exact same query setup.....it deletes them from all the tables, but then it will not add them to the 2nd, 3rd, 4th table etc etc.....it keeps saying "will append 0 entries" PLEASE HELP, otherwise im screwd lol.

 

[Bilbo_Baggins_Esq]

I suspect that your append queries may be dependant on the some of the record(s) that are being deleted, or there may be some other reason the append queries are returning zero results.

I'd suggest manually steping through each step of the macro, and when you get to the append query steps, open each queery in design view then switch to datasheet view. This allows you to look at the results of the query before it actually runs. If you see no results in datasheet view, then it wil not be appending any records. Revert back to design view and examine the query structure to find the problem. Make sure that the records you hope to append are not dependant on the records that were just deleted.