Need to figure out how to do a calculation regarding dates
Ok. I have a table for courses and a table for teams. I have the team table joined to the course table via a join table. I have a field for course start date and course end date (they are both date fields). I figured out how to get the number of days between the two and just add 1 so that I can get the total for days trained but my goal in the end is to be able to have a report where it shows all the training for each team and shows the number of days trained and the number of days remaining for the year (out of 24 days total for each team), I have to pull this report for each month so it would have to take into account the month I pulling the report for. I have no idea how to go about doing this. Any help would be greatly appreciated.