Sergey,
>Your select looks fine to me but could use a couple of small changes. I prefer to use EMPTY() function and the replacement date in IIF is irrelevant as long as it is far in the future. It can be constant than.SELECT AreaFK, StationFK, CrewFK, ;
> MIN(IIF(EMPTY(nextminor),{^9999/12/31}) AS NextMinor, ;
> MIN(IIF(EMPTY(nextmajor),{^9999/12/31}) AS NextMajor, ;
> .F. AS doMinGroup, .F. AS doMajGroup ;
> FROM premaint GROUP BY 1,2,3 ORDER BY 1,2,3 ;
> INTO TABLE maintdueISBLANK() vs.
EMPTY() is one place where my dBase roots show. And the idea of using a constant will speed the execution time. Thanks for the code review; it's been helpful.
Randy Bosma
VFP - Because life is too short to code in something else...
