VFP 6.0
How do I take one column and move it to another column when I encounter what acctg_prd it sees.
for example
(there is other column not shown in this example that need to be include in the query)
acctg_prd trans_amt
0100 45.00
0200 4.00
0300 23.00
results are:
acctg_prd trans_amt 1 2 3 4
0100 45.00 45.00
0200 4.00 4.00
0300 23.00 23.00
Thanks
Kevin Schmitt
Pengo Corporation
Laurens Iowa