Stuck in the loop

[sijeffs]

Hi All,

I am trying to extract some data from a table called account. The table contains name, id, parentid and tier No. Each account has a parent account which is in the same table and these build to form a tree. I can work out my starting tier and I know the Tier No I want to get an Id for.

I am struggling with getting the id and Parentid information into the loop so that I can move up through the tiers using the "id = parentid" relationship. I've been trying to use a For Next Loop.

Tried Hierachical grouping as well but as I need to know for example the Tier 5 account id for some data associated to a Tier 13 account I don't seem to be able to pass it down.

Any suggestions will be received with much gratitude.

Regards.

Simon

 

[Ngolem]

show us what you have tried so far....the "Crystal ball" isn't working...you have given us nothing to work with

Jim Broadbent

The quality of the answer is directly proportional to the quality of the problem statement!