Why wont this work

[JTQ911]

Im tryin to append one column to multiple tables at one time. I have a separate query that is suppsoed to append to each table, being run from one macro. It adds it to the first table, but on the second table, it says with the usual warning message "Warning, will append 0 tables" AKA, its not appending any of my entries, when it shoudl be appending 10, 20 etc etc. Why will the macro run the first query and append to the first table, but not the second??? To delete duplicate entries, i first run delete queries, and then i run append queries to add the columns again wtih teh new info.... please help, im about to throw the monitor off the desk!!!!!

 

[Rabbie]

Append queries will add extra records to the end of a table. You need to update the Table design first to include the new column and then run a update query to populate the new column.