I have a query with a running total that sums up a bunch of credit card/bank accounts.
This the result set I need:
Account - Closing Date - Balance - Running Total
-------------------------------------------------
Bus Acct - ??? - $400 - $400
VISA 1000 - 08/15/2007 - ($1500) - ($1100)
VISA 1001 - 08/20/2007 - $3000 - $1900
VISA 1002 - 08/23/2007 - ($500) - $1400
VISA 1003 - 08/30/2007 - $1500 - $2900
VISA 1004 - 09/04/2007 - ($2900) - $0
We have money flowing in and out of a variety of accounts on certain dates. The Bus Acct doesn't really have a date associated with it, but in order to make my running total work (and some other formulas I'm doing), I need to make the "closing date" (on the first record above) always equaled to the current date (the date I'm running my query).
How can I do this? I know how to write queries, but not really any other stuff. Any help would be most appreciated.
Kelly
This the result set I need:
Account - Closing Date - Balance - Running Total
-------------------------------------------------
Bus Acct - ??? - $400 - $400
VISA 1000 - 08/15/2007 - ($1500) - ($1100)
VISA 1001 - 08/20/2007 - $3000 - $1900
VISA 1002 - 08/23/2007 - ($500) - $1400
VISA 1003 - 08/30/2007 - $1500 - $2900
VISA 1004 - 09/04/2007 - ($2900) - $0
We have money flowing in and out of a variety of accounts on certain dates. The Bus Acct doesn't really have a date associated with it, but in order to make my running total work (and some other formulas I'm doing), I need to make the "closing date" (on the first record above) always equaled to the current date (the date I'm running my query).
How can I do this? I know how to write queries, but not really any other stuff. Any help would be most appreciated.
Kelly