Kevin,

Could you clarify this question a bit? Are you asking for help on creating a conditional SQL statement?


>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