Multiple Listings to Single Line

  • Thread starter Thread starter Shepheard
  • Start date Start date
S

Shepheard

I am running a query with multiple accounts with multiple divisions but I
want each account to show on one line or as one total instead of an
individual line for each division.
As I am really new to Access, how would I set the query or report to show
this to be viewed the way i would prefer?

Thank you!
 
Client number 1234 div 1 17 orders
Client number 1234 div 2 24 orders
Client number 1234 div 3 20 orders
Client number 1234 div 4 4 orders

I would really like it to be one line of Client number 1234 65 orders

Thanks!
 
The input is:

Client No 1234 div 1 20 orders
Client no 1234 dv 2 30 orders
Client No 1234 div 3 20 orders
Client no 1234 div 4 30 orders

Instead of the 4 lines I would like it to state
CLient no 1234 100 orders
 
Use a totals query --
SELECT [Client No], Sum([Orders]) AS SumOfOrders
FROM YourTable
GROUP BY [Client No];
 
Thank you. I wil try this.

KARL DEWEY said:
Use a totals query --
SELECT [Client No], Sum([Orders]) AS SumOfOrders
FROM YourTable
GROUP BY [Client No];


Shepheard said:
The input is:

Client No 1234 div 1 20 orders
Client no 1234 dv 2 30 orders
Client No 1234 div 3 20 orders
Client no 1234 div 4 30 orders

Instead of the 4 lines I would like it to state
CLient no 1234 100 orders
Click to expand...
Click to expand...
 
Back
Top