there is no place to enter 2 decimalsThat can't be true. A numeric field always has that option. Would like to see a screenshot without the Decimals option.
Select
*,
CCur([Amount]) As CurrencyAmount,
CCur([Amount] * 0.1) As CurrencyDiscount
From
YourTable
Open in new window