Aging Balances

From: <trolltec_at_my-dejanews.com>
Date: Mon, 10 Aug 1998 10:23:06 GMT
Message-ID: <6qmhm8$8sr$1@nnrp1.dejanews.com>

I have a table which contains all the transactions that take place on different accounts; transaction_date transaction_amount paid_to_date transaction_number account_number

What I'm trying to get is an aged list of amounts outstanding by account number. For example:

transaction_date transaction_amount Paid_to_date account_number 1/8/98 100 -100 111111 1/7/98 50 -75 111111 1/6/98 150 -200 111111 1/5/98 250 -100 111111

Will return account one_month two_months three_months four_months 111111 75 0 0 0

Any ideas will be greatly appreciated - please respond via email as well as the group

Thank you

Steve

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Mon Aug 10 1998 - 05:23:06 CDT