B
BrianP
I have an annual transaction history table that contains columnar billing
transactions by date such as:
Acct Inv InvDate Amt
123 987 1/15/08 10.00
456 988 1/15/08 15.00
123 994 2/15/08 10.00
456 995 2/15/08 15.00
123 998 3/15/08 10.00
456 999 3/15/08 15.00
What I need is to append/write the data to a new table that shows the
transactions in a linear format such as:
Acct JanInv JaDate JaAmt FebInv FeDate FeAmt MaInv MaDate MaAmt
123 987 1/15/08 10.00 994 2/15/08 10.00 998 3/15/08
10.00
456 988 1/15/08 15.00 995 2/15/08 15.00 999 3/15/08
15.00
Any suggestions on the best way to convert this data to a linear view in a
new table would be greatly appreciated.
Thanks.
BP
transactions by date such as:
Acct Inv InvDate Amt
123 987 1/15/08 10.00
456 988 1/15/08 15.00
123 994 2/15/08 10.00
456 995 2/15/08 15.00
123 998 3/15/08 10.00
456 999 3/15/08 15.00
What I need is to append/write the data to a new table that shows the
transactions in a linear format such as:
Acct JanInv JaDate JaAmt FebInv FeDate FeAmt MaInv MaDate MaAmt
123 987 1/15/08 10.00 994 2/15/08 10.00 998 3/15/08
10.00
456 988 1/15/08 15.00 995 2/15/08 15.00 999 3/15/08
15.00
Any suggestions on the best way to convert this data to a linear view in a
new table would be greatly appreciated.
Thanks.
BP