Insert a field in the design grid of a query or advanced filter

Insert a field in the design grid of a query or advanced filter

  1. Open a query in Design view, or open a form or datasheet and display the Advanced Filter/Sort window.

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