I have a data base which contains a STATUS field and an AMOUNT field both in the same table. In the report I am trying to place the AMOUNT in one of three columns based upon the STATUS being A (Approved), P (Pending) or X (Approximate).
I have attached screenshots from the database and the report for your review and assistance.