What's the Next Step?

This lesson, Advanced Report Design part 1, began by creating a Query that calculates the Total for each Receipt. We used the Group By and Total Row to calculate the Sum of the rental prices and Count the movies on this Receipt.

 

The Report Page Layout was edited to make a small, 2" wide printout for a Point of Sale (POS) printer.

 

In the next lesson, Advanced Report Design part 2, we will create e Subreport that lists the movies and add the Subreport to the Receipt.
 

OK, one cookie. Then, back to work!