by Roger Carlson
This sample illustrates how to create a Previous Date query.
It shows how to:
1) Display the previous date in subsquent records of a table
2) Display the previous date in subsquent records of a table over a group.
There are two methods shown here: Using 1) a correlated subquery and 2) the DMax domain aggregate function. The correlated subquery is the faster method, but it returns a non-updateable recordset. The DMax method is slower, but the recordset is updateable.
HOWEVER, it should be noted that against a large dataset, neither method will be very fast!
You can find the sample here: http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=516