>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
>
Use an expression for trans_amt, such as:
IIF(DBCR_IN = 'D', 0 - trans_amt, trans_amt)