Insert or delete a criteria row in a query or advanced filter
- To insert a criteria row, in query Design view or in the Advanced Filter/Sort window, click in the row that is below where you want the new row to appear, and then click Insert Row on the Insert menu. A new row is inserted above the row that you clicked.
- To delete a criteria row, click anywhere in the row, and then click Delete Rows on the Edit menu.