Create Macro that deletes from one table and appends another

jl2886

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.

jl2886

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

Rabbit

Quote:

Originally Posted by jl2886

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.

Create Macro that deletes from one table and appends another

re: Create Macro that deletes from one table and appends another

re: Create Macro that deletes from one table and appends another

Similar Microsoft Access / VBA bytes

/bytes/development

/bytes/it

/bytes/about