How to Format Currency in an Access Query
The Format function is a necessary tool when handling different types of numbers. The Format function can change numerical values to currency, dates, percentages and other formats. The Format function will format an expression into a string value. If coded properly, the Format function can add the two string values as if they were numerical. The output is still in the format of a string value, however.
Open the query.
Click the “Design View” icon. The query will open in design view.
Click the first box in the "Field" row.
Type “format(ColumnName,”Currency”)”. ColumnName is the name of the column you want in the currency format.