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