|
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 |
|
| |
