This MSAccess tutorial explains how to set up a text box to display the difference between two dates in Access 2007 (with screenshots and step-by-step instructions).
Question: In an Access 2007 Form or Report, I’d like to calculate/display the difference between 2 date fields (From_Date and To_Date). I want to display the number of days between ‘From_Date’ and ‘To_Date’, and if the dates are the same date, I’d like to display the result as 1.
Answer: You can create a Text Box on your Form or Report. Then set the Control Source property of the Text Box to the following formula: