Help Counting

[spcepickle]

Hi All - I have a database that keeps track of project we are working on. There are 5 categories a project can be in, the projects are in 12 different parishes, and controlled by 3 different project mangers. I would like a form or report that told me the number of project in each category that were active, the number of projects in each parish and the number of projects each project manger is in charge of. I know I can do this with queries but it is just an awful lot of them. Is there a more efficient way to do it?

 

[jdraw]

Hi All - I have a database that keeps track of project we are working on. There are 5 categories a project can be in, the projects are in 12 different parishes, and controlled by 3 different project mangers. I would like a form or report that told me the number of project in each category that were active, the number of projects in each parish and the number of projects each project manger is in charge of. I know I can do this with queries but it is just an awful lot of them. Is there a more efficient way to do it?

What is your current database structure?
Have you made a list of the "questions" you would like to ask the data? This will give you some insight into the reports you will need.
You could have a form with some buttons, and those buttons could trigger the opening of forms or reports to answer your questions.