Rename a field in a query

Rename a field in a query

  1. Open a query in Design view.

  2. Place the insertion point to the left of the first letter of the field name in the design grid.

  3. Type the new name followed by a colon.

    Change a field heading that displays in a query

Note   If you're replacing the field name Expr1 (or Expr2, and so on) that Microsoft Access automatically assigned, replace only the name, not the expression that follows the colon.