Data transfer

W

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.
 
B

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
 
W

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
 
Top