Drilldown grid functionality

[cmw]

I have an application which tracks orders by a variety of
attributes, product, size, salesperson, region, etc. I can
successfully tabulate all the results, but displaying them
is a problem. Ideally, I'd like to display a grid where
there is one row for each region totalling the sales by
product type for the week (columns for each product type).
If the user wants to see the details by salesperson in a
region, he or she clicks on the row to expand to a list of
sales people with the same category totals (AND if that
works, it would be nice to further drill down by day).
I've done this before using VB6 and a flex grid, but this
is an Access shop and I'm limited to using Access
functionality.

Any thoughts???

 

[Arvin Meyer]

What makes you think you can't use ActiveX controls in Access?

In particular, the VB6 Flexgrid works just fine in Access 2002, as does a
number of third party controls. One of the ones I use successfully is the
TList control:

www.Bennet-Tec.Com
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

 

[cmw]

Perhaps I installed it incorrectly, but after I referenced
the FlexGrid and selected it from the toolbar, I couldn't
place it on the form. I don't recall the exact steps I
followed or the errors. I'll try again.