Question:
For a table like this:
Date | Description | Amount | Balance
9/25/04 | payment on acct | 25.00 | 0.00
10/1/04 | delivery | 54.25 | 54.25
11/5/04 | payment on acct | 54.25 | 0.00
11/10/04 | delivery | 48.57 | 48.57
Is there any way I can find the account balance on 11/1/04, when I
don't have an entry for 11/1/04?
I don't want to SELECT Balance WHERE (Date = #11/1/03#); because that
won't show anything for this customer. I don't want to SELECT Balance
WHERE (Date > #11/1/03#); because that will give me an entry for every
date after that, which is too much. You and I know that, for this
customer, I'd want to search on 11/5/04, but I need this for all
customers in the database, where this simple example limits it only to
one customer.
Any help would be appreciated!
Bill