Moving data from one table to another

[Dave_cha]

Hi folks,
I'm a bit of a novice when it comes to writing code so I'm hoping you can help me.
I'm looking for some code which will cut records, that fall within a specified date range, from one table and apend to another.
I'll be creating a modal form which willl allow the user to specify the dates. I just need the code which will sit behind the 'archive' button. Thanks.

 

[ColinEssex]

You could use an update then a delete query on a macro.

Col

 

[Rich]

Should be Append then Delete

 

[ColinEssex]

Thanks Rich ...thats what I meant

 

[Dave_cha]

Thanks

Thanks guys. Don't know why I didn't think of that....I'm kicking myself as I type this (very difficult!!!)