I have to build a data tree by using MS Aceess (VBA). The idea is having a data tree with information from a table that has string and numeric values. For instance, I have a table called projects that has name of the project, time, resources, and cost, so what I want to do is building a project category data tree. We want to create a category called home project. This categeory will have all the home development projects we have done so far. I want the posibility of doing drill up and drill down, so if I di drill up the cost will be the average of all the projects within this category. I can create as many categories as posibble and each category has subcategories or childs.
USING VBA IS NOT A RESTRICTION, IF YOU KNOW ANY OTHER TOOLS THAT CAN DO THIS FASTER AND BETTER, I WILL REALLY APPRECIATE IT.