T
T. Foster
I have a query that combines Sales people & Project Managers and gives Every
Sales/PM a TeamID #.
I then run a report to get the Teams Profit % (They are listed by quarters
and by companies (we have 2)) to calculate a rolling years of profit so I can
then calculate there commissions.
What I need to do is run a query that will look at the teams and give me the
last 4 occurrences of the team working together.
I have the teams and can sort by quarters, I just need to limit the result
to only the last 4 occurrences, the team may not have worked together for a
couple of quarters so I can not just limit the dates. When I place the
quarters for the last eight I get too many results for some of the teams who
have worked together every quarter.
Sales/PM a TeamID #.
I then run a report to get the Teams Profit % (They are listed by quarters
and by companies (we have 2)) to calculate a rolling years of profit so I can
then calculate there commissions.
What I need to do is run a query that will look at the teams and give me the
last 4 occurrences of the team working together.
I have the teams and can sort by quarters, I just need to limit the result
to only the last 4 occurrences, the team may not have worked together for a
couple of quarters so I can not just limit the dates. When I place the
quarters for the last eight I get too many results for some of the teams who
have worked together every quarter.