Documentation – Queries

Second, in Design Mode, remove all of the variables in the Criteria row. Then run the query so it is in DataSheet mode. This will bring up all of the data records. Then the user can filter the data on specific fields using the ‘Filter by Selection’ or ‘Filter by Form’ buttons. See MS Access documentation on how these functions work. ................
................