Formatting Results Displayed in a Calculated Field

To use the format property for calculated fields:

1. Open the query in Design view.
2. Right-click in the calculated field.
3. Click Properties... from the shortcut menu.
4. Click in the Format box.
5. Click the drop-down arrow.
6. Click the Format you want to use.
7. Close the Field Properties dialog box by clicking the Close box in the upper right corner.
8. Run the query by clicking the Run button.

With the query open in Design view, right-click in the calculated field. Select Properties from the shortcut menu. The Field Properties dialog box opens. Click in the Format box, and click the drop-down arrow. Click the format you want to use. Close the Field Properties dialog box by clicking the Close box in the upper right corner. Click the Run button to see the results of your formatting.