Interesting, the similarity in the solutions. I suspect it would be too slow, though; but I didn't actually try it.
>Hilmar, this is a repeat post of:
>
Re: Selecting records that fall within a week Thread #
858448 Message #
858454>
>We both made the similar suggestions:
>select * ;
> from MyTable ;
> where MyDate + 1 in (select MyDate from MyTable) ;
> and MyDate + 2 in (select MyDate from MyTable)
>
>*- Mine:
>Select * ;
> From Test ;
> Into Cursor curResults ;
> Where lFlag ;
> And dTest + 1 In (Select dTest From Test Where lFlag) ;
> And dTest + 2 In (Select dTest From Test Where lFlag)
I wonder why Evelyn chose to ignore my questions.
No idea.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)