Take Control: Producer Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 More

The Little Prince, by Antoine de Saint-Exupéry

Still Before You Begin

If the DateReturned is empty, then the movie is still outstanding. You can use Is Null to limit the query to overdue movies, only.

 

Try it: Edit the Query Criteria

1. Open rptCustomerRecieptByDateSQ in design view. Add the DateReturned to your query, if it is not already there.

 

2. Change the Criteria for the DateReturned

Type: Is Null in the Criteria

rptCustomerRecieptByDateSQ
 

 

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

  4.2. Modify queries  4.2.2.   Add criteria to queries