1 Reply Latest reply on Nov 30, 2011 9:51 AM by philmodjunk

    Counting Project No occurrences

    jessieleah

      Title

      Counting Project No occurrences

      Post

      I have a table that we use to track a crew person's work history - what project they worked on, dates, position held on the projects, etc

      I included a jpg of what I'm wondering how to do, if it can be done.  I work better with pictures.

      Basically the picture show a person working 2 days on project 164 and 1 day on 2 other projects.  Rather count the days, is there a calculation that can capture the number of projects?  3 projects

      What the table is designed to do is show career development for career advancement.  So many days as a truck driver, or escort driver, or heigh poleman, etc need to be acheived before moving up a pay grade.  One of the requirements is for example: an E4 has to complete 200 days in the field and complete 5 projects.  Tracking the field days isn't a big deal - it's tracking the projects unless you look at the table and manual count how many projects were worked on in those 200 days.  I'm confusing myself and out of my technical skill set when it comes to this so I'm funmbling my words...

      Honestly, I can't even put into words what I'm looking for...please see the attached screen shot.  Sorry!

       

      Jessica

      projectcount.jpg

        • 1. Re: Counting Project No occurrences
          philmodjunk

          A summary report layout (not a portal) can easily be set up based on this table. Summary fields place in sub summary parts can then count the total days on each project and/or the total projects for each employee.

          Let's start with the simplest part, counting the days on each project to start to see if this will do what you need:

          I'll assume you have these fields in this table: EmployeeID, Date, and Proj #

          Add a summary field to this table that computes the "count of" EmployeeID.

          Put a sub summary part on your layout "when sorted by" EmployeeID.

          Put the EmployeeID and name fields in this sub summary part.

          Add a sub summary part "when sorted by" Proj #.

          Put the Proj # and the new summary field in this sub summary part.

          Delete the body part from your layout.

          Sort your records by EmployeeID and then by Proj # to group your records first by employee, then by Project # and you'll see a count of the days worked by each employee on each project.