Track project FTE per year for five years in Access?
in [General]
|
Prev: Multi select combo box using a lookup table
Next: Export to Excel from a report (getting wrong record)
From: JenMcG on 28 Apr 2010 14:21 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!
From: Dorian on 28 Apr 2010 14:31 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!
From: Arvin Meyer [MVP] on 28 Apr 2010 14:50
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" <Dorian(a)discussions.microsoft.com> wrote in message news:5C311969-F6A2-444F-99F8-E1603C002448(a)microsoft.com... > 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! |