Repost. I'm looking for help in summing from children, grandchildren, etc., in a hierarchical relationship. See original post below.
I know how to create a recordset with this data, but I don't know how to have a form's recordsource be based on a recordset created at that time. I suppose I could make a table each time, but that seems inefficient. Is that how I should go? Is there another way?
---In MS_Access_Professionals@yahoogroups.com, <runuphillracing@...> wrote :
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 (2) |
Tidak ada komentar:
Posting Komentar