NeilBelgium
IS-IT--Management
dear all,
I'm trying to create a system, based on a simple table, that tracks finances - invoices in and out, and what the cash position will be iun the future.
To my mind, we are talking a very simple table indeed-
ID
DATE
AMOUNT
The amount can be a +/- figure to denote either money coming, or money going, like a bank account.
HOW, though, can we get running totals for a particular period in time. For exalple, suppose the table has five records (sorry, using european date format!)
1 26/2/2002 +5000
2 27/02/2002 -2000
3 3/3/2002 +10000
4 4/4/2002 +20000
5 6/5/2002 -10000
how on earth can we calculate what is the balance in march, or april or may?????
really hope you can help, neil
I'm trying to create a system, based on a simple table, that tracks finances - invoices in and out, and what the cash position will be iun the future.
To my mind, we are talking a very simple table indeed-
ID
DATE
AMOUNT
The amount can be a +/- figure to denote either money coming, or money going, like a bank account.
HOW, though, can we get running totals for a particular period in time. For exalple, suppose the table has five records (sorry, using european date format!)
1 26/2/2002 +5000
2 27/02/2002 -2000
3 3/3/2002 +10000
4 4/4/2002 +20000
5 6/5/2002 -10000
how on earth can we calculate what is the balance in march, or april or may?????
really hope you can help, neil