I built a form with a subform. In the subform I have "start date" and "stop date" and "total days". The "total days" calculates "=DateDiff("d",[Start Date],[Stop Date])+1). The "+1" is because the dates are inclusive. I then created a control in the footer of the subform that "Sum" the total days column. What I need to do now is calculate the total days for the last 700 days. Anyone have any ideas?

Create a function, that takes the date range and gives you the total.

Thanks, it's working now...