Good morning,
Looking for a strategy to produce a drill down capability in either Access 2003 or Excel 2003 that is limited to the standard installation (i.e. no add ons -- such as Smart Tags).
I recommended Microsoft Project, but the project sponsor is not open to this option.
Though the sponsor is still developing the specs, the data will arrive in a microsoft comma-delimited (.csv) format (yes .xml would be better) with at least 4 levels of hierarchy. Not all hierarchies will go that deep, others may go deeper. (i.e. some may be only 2 or three levels, others may go to 5 or "n" levels).
I'm willing to use pivot tables, but I don't believe they will nest.
I'm willing to use Access Forms, but I believe they only go down to one sub-form.
I have used VBA, but it's been awhile.
Any ideas?
Much appreciated: Grnadpa Brian
Looking for a strategy to produce a drill down capability in either Access 2003 or Excel 2003 that is limited to the standard installation (i.e. no add ons -- such as Smart Tags).
I recommended Microsoft Project, but the project sponsor is not open to this option.
Though the sponsor is still developing the specs, the data will arrive in a microsoft comma-delimited (.csv) format (yes .xml would be better) with at least 4 levels of hierarchy. Not all hierarchies will go that deep, others may go deeper. (i.e. some may be only 2 or three levels, others may go to 5 or "n" levels).
I'm willing to use pivot tables, but I don't believe they will nest.
I'm willing to use Access Forms, but I believe they only go down to one sub-form.
I have used VBA, but it's been awhile.
Any ideas?
Much appreciated: Grnadpa Brian