Adding and displaying monthly sales for salesmen

Home Forums Marketing and Sales Sales Adding and displaying monthly sales for salesmen

This topic contains 0 replies, has 1 voice, and was last updated by Profile photo of Michael Smith Michael Smith 1 week, 1 day ago.

Viewing 1 post (of 1 total)
  • Author
    Posts
  • #2653
    Profile photo of Michael Smith
    Michael Smith
    Participant

    Hi,

    I have the simple query as shown in my screenshot query1. There are 2 salesmen and the query lists the total of each individual order. Salesman one has a total of $11,035 and Salesman 2 has a total of $43,700. How do I get the query to show those two totals instead of individual totals? I tried using the sum function and got the error shown in query2. Every month I want to run a query of how much the salesman has sold so I can calculate their commission.

    For More Details:
    Video content service

Viewing 1 post (of 1 total)

You must be logged in to reply to this topic.

Lost Password

Register

Pin It on Pinterest

Share This