Using Sum and Count function

  • Thread starter Thread starter KDes via AccessMonster.com
  • Start date Start date
K

KDes via AccessMonster.com

I have a query with field names number of orders, sum of total invoice, sum
of amount paid, and sum of amount owed. How do I get the sum of several
orders per customer and sums. I have tried everything in the textbook.
KDes
 
It would be helpful if you provided the SQL (Structured Query Language)
statement for your query. To view the SQL statement, click View > SQL View in
query design. Copy the SQL statement (Ctrl C) and paste it into a reply (Ctrl
V).

On first guess, without seeing the query you have so far, it appears as if
you need to add the Customers table to the QBE (Query by Example) grid. Then
add the Customer name. Specify Group By in the Totals row.


Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________
 
Back
Top