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

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
(E-Mail Removed)


"Deo" <(E-Mail Removed)> wrote in message
news:620A44D6-65D5-4351-B2BB-(E-Mail Removed)...
> 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

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" <(E-Mail Removed)> wrote in message
news:620A44D6-65D5-4351-B2BB-(E-Mail Removed)...
> 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