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.
Video of the Day
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.