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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

set null values to zero in an access query using linked tables 1
Access How to calculate the balance carried forward of individual student when payment of fee is made in ms access 2013 1
Update Table 3
COMBINING 2 QUERIES INTO 1 12
How do I query a calculated control? 1
combining queries into 1 8
combine like items in query 1
3 queries into 1 8

Back
Top