A report is for giving you a printout of your data in a specified format.
What you are asking is more in line with viewing your data. Forms are used
to view data. What you are requesting to see is easily done with forms. Are
forms more what you want?

Steve



"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