G
Guest
I have a table with the following:
EventID=number
EventName-text
EventDate=date
and some other fields
I desire to craft a query which will return a list of these events with the
span of time between each.
For example:
EventID1, EventName1, EventID2, EventName2, span of time (in days) between
the two
EventID2, EventName2, EventID3, EventName3, span of time (in days) between
the two
EventID3, EventName3, EventID4, EventName4, span of time (in days) between
the two
etc.
I have been unsuccessful in my attempts at this. I would be appreciative of
some assistance.
Thank you.
EventID=number
EventName-text
EventDate=date
and some other fields
I desire to craft a query which will return a list of these events with the
span of time between each.
For example:
EventID1, EventName1, EventID2, EventName2, span of time (in days) between
the two
EventID2, EventName2, EventID3, EventName3, span of time (in days) between
the two
EventID3, EventName3, EventID4, EventName4, span of time (in days) between
the two
etc.
I have been unsuccessful in my attempts at this. I would be appreciative of
some assistance.
Thank you.