### Title

Date calculation help.

### Post

I am very new to FMP and am learning as I construct this database so any help is appreciated.

I have a course table that has Start and End date fields. I have a Calculation field in that table that totals the days trained. I have a Team table that has two calculations for Total training days that just Sums up the Daystrained, and another calculation that subtracts the total days trained from the days alloted 26.

Here is the thing I want to be able to do with these calculations but am not sure of how to do it. I want to have it calculate for the specific year. So each year it will start over calculating up the total days trained, and the total remaining days from 26 alloted days.

Help please.

The relationship will filter the values by year as long as you refer to the correct table occurrence in your sum function.

Last Post I said:

"Link Course_Trainneetbl to Coursetbl 2 by both CourseID and Year."

That looks like this:

Course_Trainneetbl::CourseID = Coursetbl 2::CoursID AND

Course_Trainnetbl::Year = Coursetble 2::cYear

Then Sum ( Coursetbl 2::DaysofCourse )

Should compute the total trainee days for this trainee.