This is just 1 of 2 things I need to finally finish this DB I'm working with.
It's an Incident Management System.
Basically, I just have 2 tables. One for the previous month, and one for the current.
Of course, when the month ends, I need to get rid of the previous, and the currente then becomes it.
I already have something that exports all the raw data to an Excel document, as well as the graphs, so no worries about backups there.
Is it possible to have a couple buttons that do that?
1)Delete previous month
2)Move current to previous
3)Delete current.
Of course, if they could give a warning, that'd be swell.
In the case of helping out with code, the tables are simply PastMonth and PresentMonth.