troubleshooting Question

Building a Data tree with MS Access (VBA)

Avatar of mescalona
mescalona asked on
Microsoft AccessEditors IDEs
3 Comments1 Solution484 ViewsLast Modified:
Hi Experts,

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.
THANKS
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 3 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 3 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros