Pivottable-like features for Access

[Joel Horowitz]

Hye,

I would like to know if there's a simple way to have a pivottable-like feature for Access. What I need to do is to analyse a database of 15000 lines. The database has a directory structure, i.e. there are fields 'Level1', 'Level2', ..., 'Level7' which indicate the hierarchy + other fields containing numerical values. I want to be able to consolidate those numerical values at any level, and to drilldown easily. Excel does that well, but the problem is that it cannot handle (at least not on my system) such a depth + it's quite slow + formatting is lost when the table is updated.

Any hint?

 

[LTunnicliffe]

Hint: Cross-Tab Query.

You specify what you want in you rows, column and value. Access does the rest. Hope this gives you a hint.

 

[Joel Horowitz]

Hint: Cross-Tab Query.

You specify what you want in you rows, column and value. Access does the rest. Hope this gives you a hint.

Thanks for the answer, but that's not what I am looking for. I need the end-user to be able to drilldown dynamically while looking at the data, rather than having to switch between design and view modes.

 

[mdmilner]

At the risk of being wrong, I think what you're going to want to do is create subdatasheets via customized relationships between tables, although it's not really any kind of analysis capability. It's a design capability to create a relational database.