Macro to seperate months (?) (1 Viewer)

[Mud24]

I am working on a DB that records info monthly. I want the DB to do is; Store the previouse months info, clear the table so that the new months info can be inserted.

I would also need the DB to store certain statistical data so that I can refer back to it and print out monthly reports. Can ayone help?