>John
>
>Thank you,
>My question is how do I also include all of the other fields in the database.
>

Modifying the code in John's example:

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

You can also explicitly specify each field you want.