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.

Welcome to the forum!

What is your backend DB?

The query to execute would be

Select [Sales Person], Sum(Amount)
From <Your Table Name>
Group By [Sales Person]
Order By [Sales Person]