Administrator: Receipts Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 More

You've Got Questions...

Test your results. When you run the query or preview the report built from this query, a little window will ask for the name or phone.

 

Try the Parameter Query

Enter the name: Poohbah:

 

You should see that Deeter has three overdue videos. If you leave the pop up parameter blank, you should see all of the customers who have rented a video.

Home ->View ->Query Design
 

 

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

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