This is completely out of my scope. so im looking for some help, i dont think this is possible but you might think otherwise.
I have got a table with Months in it, Jan to December, a company is given a "kit fund level" between jan and decemeber however this may be renewed in the middle of the month in July for example. Every company will be different when it is renewed.
Is their anything i can use in the company table to define when the kit fund was issued and then someone use PHP to determin the total they spent AFTER the month it was issued.
So for example if it was issed in July. I would only need the total from july to december for that year rather than jan to dec.
Like i said this will change for every company so im guessing some sort of "flag" will be needed.
All advice and comments are appreciated