Is it possible to script changes to a table field?

Discussion created by medrob on Sep 1, 2016
Latest reply on Sep 1, 2016 by LabsRock


So the database at work has a series of fields that are edited manually every month. The fields calculate various changes in the database for items sold, for example, and have an average calculated per 3, 6, 12 and 24 months ending that month.


Here is an example

At the end of the month closing, each item in the database has an inventory listing to it, as well as how many were sold (Which is updated daily) The items run through an ending or closing period at the start of the new month so as to calculate a cost value, to which averages for 3, 6, 12 and 24 months are made. The fields have the following information in them (This is from an older database I am currently working on testing various things)


Average (Feb 2014;Mar 2014;Apr 2014;May 2014;Jun 2014;Jul 2014)


What I would need is a script that would eliminate the oldest month (Feb 2014, for example) and add the newest month (Aug 2014) without having to manually edit the field. This is done on every monthly average field at the end of every month closing.


On a side note, we have to manually create the month fields themselves every month before including them into the averages. If there is a script that we can run to create the newest month as well, that would be great.


Any help is appreciated.