Looping through records

[Guest]

I have a table with member names. Members can be active for multiple
periods. I need to review the begin and end dates for a specific member to
identify any breaks.

Sample:
Row 1: 01/01/2006 to 06/30/2006
Row 2: 09/01/2006 to 03/31/2007
Row 3: 04/01/2007 to current

Row 1 results should read original record (this I can do with a min statement)
Row 2 would read 3 month break
Row 3 would read current member (this too I can do by looking for null value)

Thank You

 

[Jeff Boyce]

Liz

In Access, it all begins with the data.

I can't tell, from your description, what data is being stored in what
fields in what tables. For example, are the date ranges held in a single
field, or in two (e.g., [StartDate], [EndDate])? How do you know that these
three rows all "belong" to the same individual?

More specific description may lead to more specific suggestions.

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/