Track project FTE per year for five years in Access?

Track project FTE per year for five years in Access?

Post by SmVuTWN » Fri, 30 Apr 2010 03:21:01


I need to track individuals' FTE on projects for each year of the projects,
which could be up to 5 years. The FTE could be for three different time
periods within each year (e.g., summer, school year, calendar year for Year
1, Year 2, and so on). What are the best fields to create and table structure
for this?

Thanks!
 
 
 

Track project FTE per year for five years in Access?

Post by RG9yaWF » Fri, 30 Apr 2010 03:31:01

How about using a from date and to date in a table such that you can have
multiple ranges per person.

tblProject:
ProjectId

tblPerson:
PersonId

tblAssignment:
ProjectId
PersonId
FromDate
ToDate

-- Dorian
"Give someone a fish and they eat for a day; teach someone to fish and they
eat for a lifetime".

 
 
 

Track project FTE per year for five years in Access?

Post by Arvin Meye » Fri, 30 Apr 2010 03:50:16

In addition, you may wish to add another table for Periods, so that a date
range that spans multiple periods can be attached to the assignment, or it
may be sufficient to just use the Period number instead of the date.
--
Arvin Meyer, MCP, MVP
http://www.yqcomputer.com/
http://www.yqcomputer.com/
http://www.yqcomputer.com/