Summing for a make table query

  • Thread starter Thread starter Gene R.
  • Start date Start date
G

Gene R.

I have a main table with Customers, and a payment table
which holds many individual payments for my customers.
How do I make a new table with one record for each
customer and a field which has a sum of all the payments
each customer has made?

Thank you twice!

Gene R.
 
Create a query using both Customers table and Payment
table. Put all pertinent fields in QBE grid like customer
name, payment, etc. Make it a "Totals" type query by
clicking the sum symbol button. In the total row,
change "Group By" to "Sum" for your payment amount field.
Change the query to a Make-Table query. Every time the
query runs it creates the table with new values.

I think there is a way to update the values without
creating a new table every time, but I'm not sure how.
 
Back
Top