By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
464,799 Members | 1,365 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 464,799 IT Pros & Developers. It's quick & easy.

Create Macro that deletes from one table and appends another

P: 83
Is there a way to create a macro that, based on certain criteria(disposition status and date received), removes a line from one table and adds it to another.
May 29 '07 #1
Share this Question
Share on Google+
2 Replies

P: 83
I think I will want to use SQL and select records from the table based on certain criteria, then append them to the new table, then delete them from the old? is this right
May 29 '07 #2

Rabbit
Expert Mod 10K+
P: 12,441
I think I will want to use SQL and select records from the table based on certain criteria, then append them to the new table, then delete them from the old? is this right
Yes, that's pretty much what you have to do. It'll take 2 queries. There's no Move Record query.
May 29 '07 #3

Post your reply

Sign in to post your reply or Sign up for a free account.