Example of a Query that calculates the differences between two dates The Producers: Calculating with Dates Harvest the Data for Customer Support: Most businesses are date driven. Queries can be used to look for overdue movies.   Plan: Create a new Query as the Record Source for a Report that calculates the numbers of days that each movie is overdue.   The Report will be Grouped by Customer and formatted so that there is only one customer per page. Our customers will get an Overdue Movie Report that is formatted like a letter.   What Are the Steps? Design a Query that Groups the Records by Customer and calculates the Amount Due. Then, create a Report that is formatted like a business letter.   Worth Noting: The new Query will calculate the difference between the DateRented and the current date with the DateDiff() function.