Results 1 to 3 of 3

Thread: How can I get the totals of each sales person ...

  1. Feb 16th, 2006, 10:11 AM #1
    uma123
    uma123 is offline

    Thread Starter
    New Member
    Join Date
    Feb 2006
    Posts
    1

    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.
    Reply With Quote Reply With Quote
  2. Feb 16th, 2006, 10:15 AM #2
    szlamany
    szlamany is offline
    MS SQL Powerposter szlamany's Avatar
    Join Date
    Mar 2004
    Location
    Connecticut
    Posts
    18,263

    Re: How can I get the totals of each sales person ...

    Welcome to the forum!

    What is your backend DB?

    *** Read the sticky in the DB forum about how to get your question answered quickly!! ***

    Please remember to rate posts! Rate any post you find helpful - even in old threads! Use the link to the left - "Rate this Post".

    Some Informative Links:     [ SQL Rules to Live By ] [ Reserved SQL keywords ] [ When to use INDEX HINTS! ] [ Passing Multi-item Parameters to STORED PROCEDURES ]
    [ Solution to non-domain Windows Authentication ] [ Crazy things we do to shrink log files ] [ SQL 2005 Features ] [ Loading Pictures from DB ]

    MS MVP 2006, 2007, 2008
    Reply With Quote Reply With Quote
  3. Feb 16th, 2006, 10:59 AM #3
    brucevde
    brucevde is offline
    PowerPoster
    Join Date
    Oct 2002
    Location
    British Columbia
    Posts
    9,758

    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]
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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