Drill Down Capabilities in Access

[Eric@Gopher]

Hi All

What is the best tool to use for employing the ability to use some type of drill down capability. For example: Sales toals for a business unit for a day, drill down to order level, perhaps from there to a particular state etc.... from summary to detail. any help would be most appreciated!

Thank you!

 

[plog]

An excel pivot table: http://chandoo.org/wp/2009/08/19/excel-pivot-tables-tutorial/

 

[apr pillai]

Check this out: Drill-down Inquiry Screen-2