Aggregate Queries

H

Hopeless

I need to create an aggregate query called
TOTALFORCUSTOMERS which will total the orderdetails in a
particular order for each CUSTOMER
Can anyone help?
 
D

David Wilson

Use the "group by" feature (see the little sumation icon). Learn the impact
of setting group by, sum, count, and where.
 

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

Totaling An Aggregate Expression On A Report 4
SQL Aggregate Functions Truncating Values 0
Incone & Expenses Statement 0
Sum Function Error 1
Default Value on Form Help 1
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Opinion about aggregates 8
acess sum 7

Top