Data transfer

[Wileyc]

I want to transfer data filtered by a query from Table 1 to Table 2 and
delete it from Table 1 how do I do this using a macro? Thank you for the
assistance.

 

[bob]

1. create the queries that do what you want
2. run them , in sequence, from a macro
3. You may want to setwarnings = false before those queries

Bob

 

[Wileyc]

I tried to set up the Macro however it did not work. I did something wrong.
Can you tell me the steps for seting up the Macro:
Setwarnings "No"
Openquery...ect.

Thank you