On my Access Form, I have two dates [StartDate], [EndDate] and another field [NoDays] that calculates the number of days between my two dates. Using DateDiff my calculation works fine, however, if I do not have an [EndDate] I want it to calculate from the [startDate] to today's date. How do I make this work?