SitePoint Sponsor

User Tag List

Results 1 to 2 of 2
  1. #1
    SitePoint Member
    Join Date
    Nov 2011
    Posts
    1
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Question Using Access 2007 to Collate Data

    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.

  2. #2
    SitePoint Member
    Join Date
    Aug 2011
    Location
    India
    Posts
    13
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    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
    Get Your Low Cost Website | Best website banner for your website needs


Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •