[MS_AccessPros] Summing from a hierarchy

 

I have clients set up in a hierarchical relationship. I want to be able to move (on a form) up and down the tree levels showing totals at each node for all the children, grandchildren, etc., under that node.

The key tables and fields (not all fields listed, just enough to explain, I hope) I have (so far) are:

tblClients:

  ClientID (auto)

  ClientName (text)

  ParentID (long)

tblAccounts (a client may have multiple accts)

  AcctNo (text, alphanumeric)

  AcctName

  ProductType (text)

tblParents

  ParentID (auto)

  ParentName (text)

  Parent (long, ParentID of this parent, if there is one)

  SalesRep

tblRevenue

  AcctNo (text)

  Revenue (currency)

I know how to sum from one level below, but not sure how to get beyond that.

Thanks

Adam Feerst

Denver, CO

__._,_.___

---

Posted by: runuphillracing@yahoo.com

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (1)

Visit Your Group

• New Members 1

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___