Access: Research Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28
Home-> Sort and Filter ->Advanced ->Save As Query

Save a Filter as a Query

You can save a filter as a query if you wish to run it again and again.

 

Try It: Save the Filter

Go to Home-> Sort and Filter.

Select Advanced ->Save As Query.

You will to prompted to name the query.

Name it: NewFamilyMoviesSQ.
 
 

 

  Microsoft Access 2007 Exam 77-605 Topic: 4. Creating and modifying queries

  4.1.6.  Save filters as queries