Results 1 to 2 of 2
  1. #1
    pjdube is offline Novice
    Windows 8 Access 2010 64bit
    Join Date
    May 2017
    Posts
    25

    I have a query question, generating a query to give total income by salesman but if there is another

    Hey guys, I need your help. I made an access data base which records all sales interviews, and if a salesman sells something he puts the amount in dollars. I am able to easily do a query and report on how much that salesman sells in total.



    However if the salesman has another salesman who closes a deal and gets the money in, I have to show this being divided up equally between the two. For instance Mary Jones gets seen by
    one salesman and then he calls in another salesman to help on the sale. The total sale is $5,000 and so then this would be equally divided up i.e. Salesman1 - $2,,500 | Salesman2 - $2,500

    How do I program this in a query?

    I am attaching my table so you can see what I am talking about.

    Thanks!

    Click image for larger version. 

Name:	sales.jpg 
Views:	5 
Size:	141.8 KB 
ID:	28689

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,820
    Well, maybe in query or in textbox calculations:

    Primary: IIf(Not IsNull([Tag Salesman]), [Paid]/2, [Paid])

    Tag: IIf(Not IsNull([Tag Salesman]), [Paid]/2, [Paid])
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. LIKE query does not give desired results
    By MarksinMO in forum Queries
    Replies: 3
    Last Post: 09-03-2015, 06:58 AM
  2. Copy a query and give a new name
    By Ianw in forum Access
    Replies: 7
    Last Post: 03-12-2015, 01:48 PM
  3. Replies: 4
    Last Post: 09-13-2013, 05:26 PM
  4. Query to give Subtotals of field
    By dinesh_ltjd in forum Access
    Replies: 2
    Last Post: 01-12-2013, 01:18 PM

Tags for this 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
  •  
Other Forums: Microsoft Office Forums