Another tricky selection query

[DKS]

Hi,

could not resist re-using the title of a previous question as I was just
trying to scratch my head on how to name my question.

I need a query in which the data from the previous record is referenced. to
make things simpler, here is the situation. I have a simple table that
contains 2 columns, first column contains name of an event and the second
column contains the date. There ARE NO DUPLICATE dates.

The date is the end date for the event. The start date for the event is
from the day that follows the end date of the previous event.

What I need:
A query that generates a listing of the events with the correct start and
end dates. Thus somewhere, I need to reference the end date of the record,
add 1 day to it, and display it.

Any ideas?

Thanks in anticipation.

 

[DKS]

I just found the answer whilst browsing through previous questions. It is a
reply from John Spencer to efandango.

Thanks John, your reply worked very well in my case also after a simple
tweaking.

 

[John Spencer]

Great - a twofer

Two questions answered by one response.

Of course, that is one advantage of a newsgroup. Another advantage is that
you may see more than one solution posted to the same problem..

--
John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County
..