rptMovieRentedSQ: Run!

5. Try it: Run the Query

Go to Query Tools ->Design->Results.

Click on Run.

 

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

Receipt 1 has 5 movies.

Receipt 2 has 2 movies.

That's what we wanted to see.

 

This Query is the Record Source for the Subreport, rptMovieRented-POS.

 

Done and Done. Close the Query.

Query Tools ->Design->Results-> Run