if I have a table of data like this in access :
MEMBER_ID ENROLLMENT_DATE DISENROLL_DATE Days
40000541 7/1/2007 5/31/2008 336
40000541 7/1/2008 7/31/2008 31
How can I write a query in access that can combine the Member ID who have the second enrollment date is continuous followed the disenrolled_date (highlight in red), so that I can have only record for those members. Please help. Greatly appreciated.