Consecutive Date Query Part Deux

[NeonSky via AccessMonster.com]

Good Afternoon,

Got a rather complex brain teaser for you. Please review my sample data....

TableA

LNAME ADDR1 ARRIVAL DEPARTURE CODE
Smith 12House 4/29/2008 5/2/2008
AB
Smith 12House 5/2/2008 5/6/2008
AB
Smith 12House 5/6/2008 5/13/2008
AB
Smith 12House 5/13/2008 5/20/2008
AB
Smith 12House 5/5/2008 5/11/2008
AB
Smith 12House 5/10/2008 5/13/2008
AB
Smith 12House 5/10/2008 5/17/2008
AB

Now please notice that the first 4 rows are part of a sequential set. What I
would like to happen is identify the non sequential records (the last 3) and
have them sent to a "holding table". Anyone up for tackling this beast?
Please take note that the non-sequential sample records purposely fall
within/on the ranges of the arrival/departure dates of the sequential records.
Perhaps the solution is to first pull out the sequential records? That would
work also. Thank you!!!!!!!!

 

[Ron2006]

What are you using to guarentee that you get these records in the same
sequence the next time that you read the records? They are NOT being
sorted by anything visible in the example.

Ron