This is the message I meant

Re: Birthdays this week Thread #1389309 Message #1389403

BTW, when I tried to view the whole thread, I didn't see it, so for a moment I was afraid I didn't post it, only thought I did.

>>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().