Format ms access currency field in a query

Question

Hi how can I format a currency field in a query to show without the £ symbol, but still include the correct figure after the decimal point? thanks

Answer 1

got it, it was a typo in my query!

Answer 2

In general, Access is prone to adding a currency symbol when it outputs currency columns. The simple solution is to convert the value to a numeric format like decimal, double or int (if there are no pennies):

Select CDec([MyCurrencyColumn]), CDbl([MyCurrencyColumn]), CInt([MyCurrencyColumn])
From ...