Obtain hierarchy reports (direct and Indirect)

[VirtuallyinDemand]

I was wondering if there was a way to obtain all individuals that report to a particular person (directly or indirectly) through a query. A sample of the table is below:

tbl_Hierarchy

Enumber	FName	Mngr_Enumber
E111	John	E000
E222	Mary	E111
E333	Paul	E111
E444	Sarah	E999
E555	Sam	E333
E666	Tom	E111
E777	Karen	E111
E888	Jim	E666
E999	Deb	E666

For example I would like to see everyone who reports through Tom(E666). The result should yield:

E888	Jim	E111
E999	Deb	E666
E444	Sarah	E999

Any help is appreciated. Thanks!

[June7]

What about Jim?

I expect this sort of search (recursive?) would require complicated VBA code.

[VirtuallyinDemand]

Sorry I corrected my example. Jim should be part of the output.

[June7]

Still don't think the posted example is correctly reflecting the data but is moot point. I don't have code to offer. I still think it will be very complicated. But I could be wrong.

Bing: Access VBA hierarchy search

Review: http://bytes.com/topic/access/answer...ierarchy-query