|
-
Feb 16th, 2006, 10:11 AM
#1
Thread Starter
New Member
How can I get the totals of each sales person ...
Hi,
I have to enter data for 3 sales persons in a table but with one field "Sales Person". How can I get the totals of each sales person in LABLE 1, LABLE 2 & LABEL3.
Example:
First Sales person's Total Sales in "Label 1"
Second Sales person's Total Sales in "Label 2"
Third Sales person's Total Sales in "Label 3"
The field "Sales Person" contains 3 SALES PERSONS (RAJ, RAVI & ANUP) like the following:
SL. CUSTOMER SALES PERSON AMOUNT
1 RAMESH RAJ 5,000.00
2 MANOHER RAVI 3,000.00
3 YADAV RAVI 2,000.00
4 SUMAN RAJ 6,000.00
5 REDDY ANUP 3,500.00
6 SHYAM ANUP 7,000.00
7 MURTHY RAJ 9,000.00
Help me out please.
-
Feb 16th, 2006, 10:15 AM
#2
Re: How can I get the totals of each sales person ...
Welcome to the forum!
What is your backend DB?
-
Feb 16th, 2006, 10:59 AM
#3
Re: How can I get the totals of each sales person ...
The query to execute would be
Select [Sales Person], Sum(Amount)
From <Your Table Name>
Group By [Sales Person]
Order By [Sales Person]
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|