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