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,