Building a table with tree structure

[kuukkeli]

Hi!
I have a table containing organizational structure, but it is a complete mess. All it tells is what level something is in organization and what is in upper level of it. I would like access to build it up to somekind of a tree structure so that in level 1 would be in the first column and straight underneath it would be things that are below it in the structure but in the next column.
This is just an example but it demonstrates what I want to do. The actual file contains more than 10 000 rows and levels go up to 10. And the actual data is a complete mess. All it tells is the level of the tree structure and what is on upper level.
Now they are in this form:

Level name upper level
0 berkeley (none)
1 people berkeley
1 Org units berkeley
2 UCBKL Org units
3 ACBPC UCBKL
4 AC1BP ACBPC
3 AVCIS UCBKL
4 VRIST AVCIS
5 JFAVC VRIST
5 JGMIP VRIST
5 JHSSC VRIST
5 JICCS VRIST
6 JIACA JICCS
6 JIADM JICCS
6 JIDIR JICCS
5 JJCNS VRIST
5 JKASD VRIST
5 JLSTP VRIST
3 CENTR UCBKL
3 CHANC UCBKL
.
.
.


And I would like them to get into this tree structure like in this example.

So I would need somekind of script, but I am utter newbie with access. So how should I start?

 

[John Big Booty]

Welcome to the forum.

Perhaps this article will give you some pointers.