I have a database of projects. I would like to have a count of projects that are open or in progress (field=status). I also have categories for the projects (research, exempt, posters and HUD) and I would like to have a count of how many there are in each category. I can't make a query or report do what I want. Could anyone give me a suggestion? Thank you.
Assuming "Projects" is the name of table that holds your projects and "Category" is the table that has the category definitions. I am also assuming categoryId is a FK to the projects table
The query should look something like this
Select categoryName, Count(projectID)
From Projects p inner join Category c on p.categoryId = c.categoryId
Where p.status in ('open','progress')
Group by categoryName