Here's what I have...
A table of Employees (EMP) with a field that identifies who their Boss (BOSS) is. A table of Sales Volume (SV) conducted for each Employee.
What I need to do...
Construct a query to give me a total of their Personal Sales Volume AND the Group Sales Volume including all Employees below them.
Example:
EMP BOSS PSV GSV
John 0 650
Bob John 350 550
Nick John 100 100
Dave Bob 100 200
Steve Dave 100 100
Thanks for all the assistance ahead of time.
Justin
A table of Employees (EMP) with a field that identifies who their Boss (BOSS) is. A table of Sales Volume (SV) conducted for each Employee.
What I need to do...
Construct a query to give me a total of their Personal Sales Volume AND the Group Sales Volume including all Employees below them.
Example:
EMP BOSS PSV GSV
John 0 650
Bob John 350 550
Nick John 100 100
Dave Bob 100 200
Steve Dave 100 100
Thanks for all the assistance ahead of time.
Justin