Test the Query

Well, there are several Expressions in this Query. The only way to know if it works is to Run it and review the results. Let's run.

 

7. Try it: Run the Query

Go to Query Tools ->Design->Results->Run.

 

What Do You See? The rptOverdueSQ Query calculated the following:

DaysRented

Rental

Overdue

 

Save. Save. Save.

Query Tools ->Design->Results->Run

Exam 77-885: Microsoft Access 2010

4. Creating and Managing Queries

4.3. Manipulate fields: Create a Calculated Control