C
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???
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???