Add and Delete queries deleted the source table

[ItaiMeir]

Hey all,

I did a query that adds part of one table to other table, and another query that delete the table before activating the add query.

When i run the macro that activate the delete and add queries, sometimes the records from the mother-table (the one that gives the data) delete;
always from the same record.

anyone have idea what might cause it?

Thanks, Itai

[ranman256]

You don't delete data before you copy it.
1 copy the data
2 then delete the data