Calculate Totals in a
use this Query to calculate the Total for each Receipt. The first
step in calculating the Totals is to Group the data. The
Records will be Grouped By ReceiptID first so that each
Receipt can be totaled separately.
Try it: Show the Total Row
is open in Design View.
Query Tools ->Design->Show/Hide
What Do You See? There should be a new Total Row in
the QBE Grid. The Totals Row has Group By as the value for
Total Row is shown and ready to go. Keep going...