This post explains it well:
http://www.eggheadcafe.com/forumarch...st25773951.asp

Lots of other reporting tools and graph components support drilldown.
For example Microsoft SQL Server Reporting Services (just to stay with
microsoft tools)

You could use forms to do this and have various button to launch a report at
the level of detail needed.

Try a google search on "drill down reporting tools"
HTH,

--
Mark Andrews
RPT Software
http://www.rptsoftware.com
http://www.donationmanagementsoftware.com

"Deo" wrote in message
...
Hi,

I have a report grouped by Office (4), Department and then by Managers.
The
staff and the funtions are in the detail section. Is it possible to have
a
report - a sort of drill down report that would first show all the office
totals and you can then click on an office and see all the department
then
click on a department and see all the managers and finally click on a
manager
to see the detail for that manager.

If this cannot be done in Access does anyone know of another viable
solution.

Thanks