=IIf([From_Date]=[To_Date],1,DateDiff("d",[From_Date],[To_Date]))
MS Access: Set up a text box to display the difference between two dates (display value of 1 if dates are the same) in Access 2003/XP/2000/97
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:
