Question

Are there any advantages to sorting query results using SQL rather than using the Query Design window?

Answer 1

Answer:

Queries retrieve rows and columns from tables. After you run a query, you can further limit the number of items shown in the datasheet by applying filters. Filters are a good choice when you want to temporarily limit the query results without going into Design View to edit your query.