Add fields to the design grid in a query or advanced filter

In a query, you add only those fields whose data you want to view, set criteria on, group by, update, or sort. In an advanced 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. Open a query in Design view, or open a form or datasheet and display the Advanced Filter/Sort window.
   
   
2. In a query, make sure the field list for the table or query containing the fields you want to add appears in the top portion of the window. You can add a table or query if the field list you need isn't in the query.

   How?

   In the Advanced Filter/Sort window, Microsoft Access displays the field list for the underlying table, query, or SQL statement automatically. You can't add more tables or queries to this window.

3. Select one or more fields from the field list and drag them to the columns in the grid.

   How?