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

Enter the Parameter Value

Try It: Run the Parameter Query

Go to Query Tools-> Design ->Run

You will be prompted to enter a rating.

Test the query with PG, please.

 

Memo to Self: This query has a subquery that asks for the Rating. The subquery also filtered the movies so that all of the movies were released after 2000: no moldy oldies!
Query Tools-> Design ->Run
 
 

 

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

  4.2. Modify queries   4.2.2.   Add criteria to queries: Parameters