On Mon, Nov 22, 2004 at 03:59:14PM -0000, Keith Watson wrote:
From: Chris Green Sent: 22 November 2004 13:40
I'm steadily progressing with my conversion of my Access accounting system to a Linux based system.
I've moved from using mysql to postgresql which has made a few things easier by having VIEWs in the database.
Rekall seems to have most of what I need on the forms and reports front except for one thing - I can't see how to implement a 'running total' column.
The Access97 report tool has a specific 'running total' column type which does exactly what I need. Rekall doesn't have anything like this (that I can see).
Has anyone got any bright ideas of how I can do this, it's rather vital on things like a Bank Reconciliation report to enable me to check my accounts against the bank statement.
-- Chris Green (chris@areti.co.uk)
can you give a specific example as 'running total' covers a lot of ground :o)
Yes, of course, I want a report that looks like:-
Date Description Amount Balance 01/09/04 Initial balance +1000.00 1000.00 03/09/04 Stamps -14.58 985.42 06/09/04 Network Card -9.99 975.43 12/09/04 Interest +0.10 975.53
etc.
It's a little more complicated than the above but that shows the essentials. (I don't guarantee my arithmetic is correct)
The Date, Description and Amount columns are directly from a database table. The Balance column needs to ba calculated as the report is created.