Archiving Ms Access 2007

[sameerkadoo]

Hello,

How do i archive Ms Access 2007 table records with specific date?
Any easy way to do it without writing any macros?



Regards,
Sam

[John_G]

What do you mean by "archiving"? If you mean just moving records to an archive table and then deleting them from the main table, you can do it with two queries - an append and a delete.

If you mean something else, please provide more detail.

John

[sameerkadoo]

I did the append and delete and it worked..... Done!!!
Please mark as solved!