Run the Query

When you Run the Query you should see how many movies (CountOfMovie) and how much they cost (SumOfPrice) are on each Receipt.

 

3. Try it: Run the Query

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

 

What Do You See? The rptReceiptSQ Query returned two Records this time:

ReceiptID 1 has 7 movies for $17.50.

ReceiptID 2 has 2 movies for  $9.00.

 

Not bad.

 

Save and Close the Query. We have the Record Source for the Receipt Printout, now.

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

Exam 77-885: Microsoft Access 2010

4. Creating and Managing Queries

4.3. Manipulate fields: Calculate Totals