Run the rptReceiptSQ Query

5. Try it: Run the Query

Go to Query Tools ->Design->Results.

Click on Run.

 

What Do You See? The rtpReceiptSQ Query returned seven Records.

On Receipt 1 CustomerID 2 has 5 movies.

On Receipt 2, CustomerID 3 has 2 movies.

 

So far so good. Let's return to the Design View. We can make a few improvements.

Query Tools ->Design->Results->Run