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!