Track project FTE per year for five years in Access?

J

JenMcG

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!
 
D

Dorian

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".
 
A

Arvin Meyer [MVP]

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top