Employee Table Query

[cstimart]

I have an Employee table that I'm trying to report off of where each employee listed has a field that also lists their manager.

I would like to display/query a list of employees for each manager, but it would also need to display the employees that report to those employees, etc...

Some records are easy as there's only 1 level, but others are more difficult. For example, the President will have a list of employees that will be SVPs, VPs, Dept Mgrs, etc...

Any ideas would be greatly appreciated.

Thanks1

 

[ranman256]

i would think , the tEmp table has a field [MANAGER] long (id)
The President's will be empty.
all the VPs will have the Presidents ID
etc..

then you can select 1 manager id, and list all those that have his ID.
query all emps to get all managers, then run thru that list to produce the entire company structure.

 

[cstimart]

I'll give this a whirl...thx

 

[HiTechCoach]

What you should have is called a Self Join

See: Microsoft Access tips: Self Joins