R
radd
MS Access 2002
I have a table that is set up like this:
ID,LINE,FEEDS,DEPTH,VALUE_A
The FEEDS column references the line column, The first row FEEDS is null
which makes it the first parent node. I need to find a way to get the sum of
Value_A for each LINE that includes the VALUE_A for each child and so on.
This is a link to a page that may help in describing what I need:
http://www.geocities.com/nor_rin_radd/treequery.htm
I have looked into the ADODB shape function but I really dont know if thats
the best way to do this. Any help would be appreciated, I'm kind of in a jam.
Thanks
I have a table that is set up like this:
ID,LINE,FEEDS,DEPTH,VALUE_A
The FEEDS column references the line column, The first row FEEDS is null
which makes it the first parent node. I need to find a way to get the sum of
Value_A for each LINE that includes the VALUE_A for each child and so on.
This is a link to a page that may help in describing what I need:
http://www.geocities.com/nor_rin_radd/treequery.htm
I have looked into the ADODB shape function but I really dont know if thats
the best way to do this. Any help would be appreciated, I'm kind of in a jam.
Thanks