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.
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.
Step 4
Type "format(ColumnName,"Currency")". ColumnName is the name of the column you want in the currency format.
Video of the Day
references & resources