counting total of reports to a manager

[thread]

Hi,

i need to build a query that counts the number of people reports to a
manager all should include their direct and indirect repots
i have the id number of the individual and the id of the of the
individual that is his manager
for now i just manage to build a query that count the number of direct
reports(counting number of supervisors) and thier one level of
indirect report but in case someone reports to the second level i
cannot track it

anyone have good idea for a query?

 

[KARL DEWEY]

It is rather difficult to construct a query to extract data from a database
without any knowledge of the table structure. Need to see what you see!
Post table and field names with datatype. Post sample data.