How to Format Currency in an Access Query

Techwalla may earn compensation through affiliate links in this story. Learn more about our affiliate and product review process here.

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.

Advertisement

Step 1

Open the query.

Video of the Day

Step 2

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

Step 3

Click the first box in the "Field" row.

Advertisement

Step 4

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

Video of the Day

Advertisement

Advertisement

references & resources