Show All

Add or remove a field in the design grid (MDB)

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

   • Select the field by clicking its column selector, and then press the DELETE key.

     Note  When you remove a field from the design grid, you're only removing it from the query or filter's design. You're not deleting the field and its data from the underlying table, nor, in the case of a filter, are you removing it from the filtered results.