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

Calculate the Discount

What Do You See? When you run the query, you should see a list of movies that match the value that you typed into the Parameter: PG.

 

The query also has a filter on the Year, so all of the movies should be released after 2000.

 

The Discount is a calculated field. Does it subtract a dollar from each rental price?
Form Design Tools-> Design-> Property Sheet
 
 

 

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

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