How to set reports of previous months?

[petitnice]

Hello!

I just created a database for our HR department showing CURRENT information. But I need to be able to keep a track on the changes that I have been made in the previous months. Especially for salary, I need to be able to print salary reports of the previous months. Can someone help me with an easy solution??

My idea (quite complicated!!) is to transfer automatically at the end of each month the info into the next month. Is this the right way?

Thanks for your help!

[Ender]

The solution depends on your current structure and what you need to store, but it probably won't be just a calculation.

You could just keep the historical data in place and recalculate from that as needed. Or you could set up a table that's meant to hold specific aggregate data from different moments in time.

[petitnice]

Hi,

The info I need to store every month is for example salary, social insurance, paid tax... The monthly overview enables me as well to make reports and evolution statistics.

You would thus recommend me to set a table with a monthly overview. When a new month starts, let´s say February, the user should get automatically in the column "Februray" the values of Januar. For that, I would create a script to get the information; but how can achieve that this script will be only done ONCE and at the 1st day of every month?

Thanks