>>Try
>>

>>SELECT * FROM theTable 
>>	WHERE 
>>			DATE( YEAR( ldStart ), MONTH( dob ), DAY( dob ) ) BETWEEN ldStart AND ldEnd
>>		OR 
>>			DATE( YEAR( ldEnd), MONTH( dob ), DAY( dob ) ) BETWEEN ldStart AND ldEnd
>>

>
>Thanks, I think that is fairly close to what I need.
>
>The date() function in your example would fail fail if a person happened to be born on Feb. 29 - I believe that I'll have to convert those dates to Feb. 28, using an iif().

People born on Feb. 29 have birthday every 4 years :)