If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Track project FTE per year for five years in Access?
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! |
#2
|
|||
|
|||
Track project FTE per year for five years in Access?
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". "JenMcG" wrote: 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! |
#3
|
|||
|
|||
Track project FTE per year for five years in Access?
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.datastrat.com http://www.accessmvp.com http://www.mvps.org/access "Dorian" wrote in message ... 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". "JenMcG" wrote: 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! |
Thread Tools | |
Display Modes | |
|
|