Delete Query?

[bunji]

I have created a query that append all the records to another table3 that are older than two years. But at the same time delete from the original table1.

If i was doing it from a form i would

DoCmd.OpenQuery "MoveQuery"
DoCmd.RunCommand acCmdDeleteRecord

However it will be moving several records at a time any ideas?

Secondly Table1 has a 1toMany Relationship with the table2, how can i move the records from table2 to table 4 at the same time. Will the data keep its relationship?

Please help.
Many THanks

 

[faradhi]

Break it up in several queries.

Run an Append to the new table and a delete query from the old table.