Hello,
I have a database that has a table with list of employees and a number of tables with sales by employees and associated payments by month.
What I'm trying to do is determine the income generated from sales of the subset of employees (read list of employees mentioned in last sentence) in a given period. I can do this for 1 month, but when I try to add multiple months the results seem to duplicate. I can't work out why.
I think its an easy solution but I'm just missing a basic and can't work it for the life of me.
Hoping you can help