Customize a Find Unmatched query

After creating the query with the Find Unmatched Query Wizard, you might want to modify the query design to produce different query results by moving, adding, or removing fields.

Move fields

  1. Open a query in Design view, or open a form or datasheet and show the Advanced Filter/Sort window.
  2. Do one of the following:

    To select one column, click its column selector.

    To select more than one adjacent column, drag across their column selectors.

  3. Click the selector of any one of the selected columns again, and then drag the field or fields to their new location.

    Change the order of fields in a query by moving them

    1  A selected column

    2  The pointer changes to a rectangle during the move

     

Add or remove fields

  1. Open a query Design view, or open a form, report, or datasheet and show the Advanced Filter/Sort window.
  2. Do one of the following:

    Add a field

    In a query, you add only those fields whose data you want to view, set criteria on, group by, update, or sort. In a filter, you add only the fields you want to use for sorting or specifying criteria, and Microsoft Access will automatically display all the fields in the filtered results.

    1. Select one or more fields.

      How?
      To select Do this
      A field Click the field name.
      A block of fields Click the first field in the block, hold down SHIFT, and click the last field.
      Noncontiguous fields Hold down CTRL as you click the fields.
      All fields Double-click the title bar of the field list or click the asterisk (*).

    2. Drag the field from the field list to the column in the design grid where you want to insert it.

      Tip   Instead of dragging, you can also add fields by double-clicking the name in the field list or selecting a field directly from the list box in the Field row on the grid.

    Remove a field