You might want to use tags so you can format this a little better. I tried to look at it, but it was to hard to understand in its present format.

PF

>>
>>How about posting the query?
>
>Here it is:
>
>SELECT PROPERT3.BORO, PROPERT3.BLOCK, PROPERT3.LOT, PROPERT3.TAXYEAR,;
> CERTFILE, certothr, REQUEST,AUDITOR, COMPLETE, CONFREQ1, CORPCOUN, CONFDATE,;
> RESULT, RJIFILED, NOTES FROM PROPERT3 LEFT OUTER JOIN CONFSTAT ON ;
> PROPERT3.BORO+STR(PROPERT3.BLOCK,6,0)+STR(PROPERT3.LOT,6,0)+;
> STR(PROPERT3.TAXYEAR,4,0)= CONFSTAT.BORO+STR(CONFSTAT.BLOCK,6,0);
> +STR(CONFSTAT.LOT,6,0)+STR(CONFSTAT.TAXYEAR,4,0) INTO CURSOR TMP_CURS;
> WHERE (CERTOTHR = 'Y' OR CERTFILE <> {}) ORDER BY PROPERT3.BORO,;
> PROPERT3.BLOCK, PROPERT3.LOT, PROPERT3.TAXYEAR, CONFDATE