Hi,
My table has a field AccType and it can contain 1 of 4 values on each record with an Amount for each. I need to create a table with those 4 columns and matching Amount. I'm sure this can be done but I can't picture how.
Table1 has 3 or 4 possible value CB, TL, PA and PAC
it also has the "amount" field for each record.
My current Table:
AccTYpe Amount
CB 5
TL 3
PA 20
PAC 6
I need to break out Table1 in his manner
CB TL PA PAC
5 3 20 6
5 2 8 0
Can anyone explain how this is done?
Thanks
CJ
My table has a field AccType and it can contain 1 of 4 values on each record with an Amount for each. I need to create a table with those 4 columns and matching Amount. I'm sure this can be done but I can't picture how.
Table1 has 3 or 4 possible value CB, TL, PA and PAC
it also has the "amount" field for each record.
My current Table:
AccTYpe Amount
CB 5
TL 3
PA 20
PAC 6
I need to break out Table1 in his manner
CB TL PA PAC
5 3 20 6
5 2 8 0
Can anyone explain how this is done?
Thanks
CJ