How to Format Currency in an Access Query

By Launie Sorrels

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 1

Open the query.

Step 2

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

Step 3

Click the first box in the "Field" row.

Step 4

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