querry or find for report

[Don Bryant]

how would I set up a way to enter a name and find all the people who report
to them even if it is 6 tiers deep meaning managers reporting to managers who
have supervisors who have team leads who have people reporting to them

 

[kagard]

how would I set up a way to enter a name and find all the people who report
to them even if it is 6 tiers deep meaning managers reporting to managers who
have supervisors who have team leads who have people reporting to them

Hi Don:

How is the data stored? Does each record in the employee table have
the employee id of that employee's supervisor? If so, you could try a
variation on a self-join query. That is, add multiple copies of the
employee table to a query and join the supervisor id of the first
table to the employee id of the second, etc. as many levels deep as
you want to go.

Keith

 

[Don Bryant]

--
Don Bryant

Hi Don:

How is the data stored? Does each record in the employee table have
the employee id of that employee's supervisor? If so, you could try a
variation on a self-join query. That is, add multiple copies of the
employee table to a query and join the supervisor id of the first
table to the employee id of the second, etc. as many levels deep as
you want to go.

Keith

Keith yes that is what I have done and I have done that 5 times to create a heiarchy of who reports to who from the bottom to the top. I need to be able to put in a name of a manager and that should pull up a report of everyone who reports to him an all of the people below to the bottom. This may be one tier or 6 tiers deep and may have only the one manager and those people who report to him or it could be a manager who has managers reporting to him who have manager reporting to them and all the people reporting to all the managers at all the levels they appear in. There is no straight level of heiarchy it changes each week so I have to import a new file each week of managers and people who report to them.