search and group results

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to able to search an agreement table for customer names and group all
matching names along with the balance for all their agreements and get a
total balance for that customer. Is this possible, I am new to this.

Thanks in advance.

Chris Cooil
 
use a totals query, filter for the customer you want, use
SUM([Balance]) Read the help file on totals/summary queries.
 
Back
Top