I'm totally stuck and hoping someone can point me in the right direction here, be it with the TreeView control within Access, or to a third-party control (i'm kinda assuming it's gonna be the latter option)...
I have data in a table that looks like this:
FundingYear ReferralYear TotalDollars TotalUnits
2008 Total 1000 50
2008 2010 750 35
2008 2009 250 15
2007 Total 1200 80
2007 2009 850 65
2007 2008 200 10
2007 2007 150 5
What I'm really hoping to get here is a treeview, where the top branch shows the "Total" line...so as an example you'd see 2008, Total, 1000, 50...
Then, when expanding the branch, you'd get the individual lines that make up the total...
I can't for the life of me see how to do with with the common treeview control, but maybe I'm missing something...
Can anyone help?
Thanks so much in advance, and sorry for posting in multiple groups...
Rob