Hi,

I'm wondering if it's possible to do the following in SQL:

Let's say I have a transaction file with amounts added and subtracted. The
file simply has the format:

DateTime : Timestamp;
Amount : Currency;


Fromt this I want to perform a query that will show me each record, the
amount, and a running balance.

ie:

DateTime    Amount    Balance
1/1/8           $1.00        $1.00
2/1/8           $3.00        $4.00
3/1/8          -$2.00        $2.00

etc, etc

Is this possible to do with SQL?

Thanks & Regards

Adam.

Hi Guys,

Don't worry - figured it out! RunSum's the answer.

Cheers

Adam.