I must be very tired today, I'm having trouble with this one.
I have a whole heap of transactions in a database. Each transaction has a MSQL Date recorded in it. Date format is 0000-00-00. A typical date recorded in the database is 2004-12-24 (yyyy-mm-dd).
I have created a list of transactions that, whilst drawing the table containing transactions, will create a subtotal at the end of each day. This works really nicely and is done when the whole date changes.
What I want to do now, is do the same, but with the month. When the month changes, I will create a monthly subtotal (then yearly etc).
So, the question is (finally
Take note there is a loop that parses through the transactions table, and draws each transaction in a linear fashion, so it's very easy to compare one transaction with its previous one.
Any advice would be appreciated...
Rob