Query Design Question Access 2007

  • Thread starter Thread starter Carl
  • Start date Start date
C

Carl

This is difficult to explain:

I have a table in my DB with three fields of interest, Name, Manager, Job
Discription
All 9800 employees are listed in the Name field, and their Manager is in the
Manger field. All the Managers are in the Name field (they are Employees as
well as Managers) and the managers Directors (listed as Dir of .....)are
listed as their Managers.
The manager of Directors is a Sr Dir of .....
and so on.
I am trying to create query to show the relationship of all the employes and
who they report to.
The layout should be
[Name] [Manager] [Director] [Senior Director] [Vice President]
etc.........

I will then base a report on this qurey. Please help.
Thank you
Carl
 
So, are you saying that if Joe is just a simple employee that doesn't report
to anyone, you want his name followed by his manager, director, senior
director, VP, with all of those names in that row?

Will the top buy in each chain always be a VP? So that if John Reports to
Steve, and Steve doesn't report to anyone, how do you want them to show up in
your format:

[Name] [Manager] [Director] [Senior Director] [Vice President]
John Steve


--
HTH
Dale

email address is invalid
Please reply to newsgroup only.
 
Your assumption is correct.
If John Reports to Steve, and Steve doesn't report to anyone then
[Name] [Manager] [Director] [Senior Director] [Vice President]
John Steve

if Steve is a Vice President, but to complicate this Steve might be a Senior
Director who reports to someone above him in the Corporate pecking order.
Most of those whose supervisors are several levels above are administrative
type people, like Admin Assistant or a Go-Fer with a contrived title to
justify his existance.

Dale Fye said:
So, are you saying that if Joe is just a simple employee that doesn't report
to anyone, you want his name followed by his manager, director, senior
director, VP, with all of those names in that row?

Will the top buy in each chain always be a VP? So that if John Reports to
Steve, and Steve doesn't report to anyone, how do you want them to show up in
your format:

[Name] [Manager] [Director] [Senior Director] [Vice President]
John Steve


--
HTH
Dale

email address is invalid
Please reply to newsgroup only.



Carl said:
This is difficult to explain:

I have a table in my DB with three fields of interest, Name, Manager, Job
Discription
All 9800 employees are listed in the Name field, and their Manager is in the
Manger field. All the Managers are in the Name field (they are Employees as
well as Managers) and the managers Directors (listed as Dir of .....)are
listed as their Managers.
The manager of Directors is a Sr Dir of .....
and so on.
I am trying to create query to show the relationship of all the employes and
who they report to.
The layout should be
[Name] [Manager] [Director] [Senior Director] [Vice President]
etc.........

I will then base a report on this qurey. Please help.
Thank you
Carl
Click to expand...
Click to expand...
 
Back
Top