Walter,

Thanks for the tip.

As it turns out, and I do not recall if I already sent this in, but my problem was placing a condexpr as a WHERE CondExpr not as part of a JOIN ... ON CondExpr1 AND CondExpr2. Why it made all the difference is beyond me but it did.

Thanks,

David

>David,
>
>>WHERE IIF(lcEmplAbbr='ALL',.T.,empl_abbr=lcEmplAbbr)
>
>You could change this in:
>WHERE lcEmplAbbr='ALL' OR empl_abbr=lcEmplAbbr
>
>I figure that lcEmplAbbr is a memory variable. Maybe you can construct your SQL at forehand in a string and leave this WHERE CLAUSE out when lcEmplAbbr='ALL', just speeding up performance.
>
>Succes,
>
>Walter,