Totals from related field

  • Thread starter Thread starter jb
  • Start date Start date
J

jb

I'm going to try asking this again in a simpler way.
For the two basic tables, Customers and Invoices, I want
a report that shows the TOTAL SAmount of all invoices for
each customer. NOT the individual invoices. ONLY the
total $amount of invoices for each customer.
EG:
Customer Table Invoice Table
Alice Walker $150, $500, and $300, and James Jones who
has 4 invoices of $600, %400, $500, and $300, all I want
to see is the following two lines:
Alice Walker $ 950
James Jones $1800

I can do this in a subform already by putting the total
in the footer of the subform. But I don't want to show
the detail records, just the value of the total.
 
You can set the Visible properties of the text boxes
of information in the detail area to No, and make them a
small size, and make your detail are smaller.

or

You can use Select queries and utilize the Totals
option at the top of the design screen to get the sums
associated with each of your tables, then place them in
your reports.

Casey
 
Yes, I learned this one the hard way, too. But don't be
too hard on yourself. All problems are "simple" once
they're solved. :^)
 
Back
Top