Query in Access based on Date Range

[liliya13]

Hi everybody

Could you please help me with my problem?

I am trying to distinguish eligible members from non-eligible and I need all eligible in to a table Eligible and non-eligible into a table nonEligible. I need all fields from the original table. I have a source file in Access XP format. Startdt and stopdt are formatted like 6/1/2002

1st level (criteria) is the following:
********************************

members are considered to be enrolled when
stopdt-startdt=enrl_range >=90 days and part of this range should be after Sep 30,2003



There might be a case when there are duplicate records while both records meet the above criteria. In such a case longer enrollment should be stay in Eligible Table


2nd criteria
**********************************
members are eligible for service if they are in Program from Sep1 2003 to April 30 2004

Thank you in advance,

With respect,

Liliya

 

[PHV]

And what have you so far ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244