Hi Kevin,

SELECT IIF(dbcr_in="C",trans_amt,-(trans_amt)) AS value FROM table


>In Visual FoxPro 6, how in a query designer do you change all debit account to negative and keeping your credit positive and also keeping the same amount of records.
>
>
>for example
>
>trans_amt DBCR_IN
>64.76 D
>34.65 C
>
>the results would be
>
>trans_amt DBCR_IN
>-64.76 D
>34.65 C
>
>Kevin Schmitt