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