Remove a field from the design grid in 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. Select the field by clicking its column selector, and then press the DEL 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.