Date Field: Get number BETWEEN one record and the next... (1 Viewer)

[Randomblink]

Ok.
I have a mowing report.
There is a date field that shows when the MOW job was done.
I have another field that needs to show the amount of time that elapsed between one job and the next...

For instance...

[mowdate] - [daysbetween]
[1/01/2004] - [0]
[1/07/2004] - [6]
[1/14/2004] - [7]
[1/28/2004] - [14]

I hope that makes sense...

Ok... So, I need to calculate the DAYS SINCE LAST MOWING FIELD...
I have been doing databases for years, but I can't wrap my head around that one? Hopefully someone else has perfected this little trick and can help me...

 

[Rich]

Use the Tag property to hold the previous value

 

[Randomblink]

Tag Property?

Rich...
Can you be a little more specific?
I have utilized the TAG for holding values in Forms before...
But never in Reports... What do you mean?

 

[Rich]

There's an example in this Report
http://www.access-programmers.co.uk/forums/showthread.php?t=38244