Insert a field into a result set

Microsoft Query

Show All

Insert a field into a result set

  1. Click the column heading of the field to the right of where you want to insert the new field.
  2. On the Records menu, click Insert Column.
  3. In the Field box, select the column you want to insert.

    If you want a more descriptive heading for the column, type it in the Column Heading box.

  4. Click Insert.

Note   To quickly insert a field into a result set, you can drag a field from the table pane to the result set.