Retrieving a hierarchial structure Report using a query or reports

S

SUBRAMANYAM

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.
 
L

Larry Linson

"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
 
S

SUBRAMANYAM

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
 
Top