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.

...

Step

Open the query.

Step

Click the “Design View” icon. The query will open in design view.

Step

Click the first box in the "Field" row.

Step

Type “format(ColumnName,”Currency”)”. ColumnName is the name of the column you want in the currency format.