Modify a filter in the Advanced Filter/Sort window

Modify a filter in the Advanced Filter/Sort window

While you're working in the Advanced Filter/Sort window in a table, query, or form, you can modify the filter's design and change the design grid.

What do you want to do in the design grid?

Add a field

Insert a field between other fields

Move a field

Add a column

Remove a field or column

Change column widths

Insert or delete a criteria row

Enter criteria

Specify a sort order for the filtered records

Clear the design grid