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
Kevin Schmitt
Pengo Corporation
Laurens Iowa