i am using microsoft access to view SQL.I need help on how to set a column to currency [this column result after multiplying the number of units bought(UNIT_BOUGHT) and the unit price(UNIT_PRICE)(unit price is in currency)].So the results are named SUBTOTAL,i want them to contain currency. LudereMP