Retrieving a hierarchial structure Report using a query or reports

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am unable a retrieve a hierarchial structure report based on two colums
from a single database table. Let me know either a way to generate a
hierarchial structure from MS Access reports or to retrieve the data from a
MS Access database query in the hierarchial structure.
 
"Hierarchical structure" could mean a lot of things. Please clarify. If you
are talking about "self-join" of a table to itself, that is certainly
possible (but you do need to know the maximum number of levels you allow).

Larry Linson
Microsoft Access MVP
 
Linson

Thank U for replying to the query posted by me.

What I am looking for is for getting the data as is done in Oracle by
writing the query
"SELECT empno, mgr FROM employees START WITH empno =1 CONNECT BY PRIOR empno
= mgr"

Hope U can help me out to retrieve the data in this form using MS Access
Database query or MS Access reports.

Bye

subramanyam
 
Back
Top