This content has been marked as final. Show 1 reply
You'd need to determine the b/f then apply it against the transaction records when they are pulled for a date range. So if the date range is
Feb 1st, 2009 -> Feb 28th, 2009
You'd need to also get the previous balance in a separate query, then use it to correctly display the running balance when you output the date range.
I suppose a simpler way involving a little more DB work (and possibly lots of coding) is to store the current balance as well with each transaction; then when performing a date range you'd have the balance as well and not have to calculate it on the fly.