Dear Richard, Can you please help. I have one date field and want to show the days between each record in a text box or label when I move from one record to the next. Want to display the number of days from the last record date to the next date in the table. Is that possible. I have been looking at the DateDiff function, but seems like you need a start date and end date. I want to move between one date field and show the days. It might be like the running sum technique, not sure.
Your Help would be greatly appreciated
You might have already covered this and have searched everywhere with my records. Cannot find.
All the Best Selby.

---

Reply from Alex Hedley:

You could use a combination of DMAX, DMIN, DateDiff