Thanks, I should know that. That should teach me to reply late on a Sat nite.

PF

>>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
>
>
>Perry - the tags need to be set off with spaces around the < and > symbols in your text to prevent them from being formatted out and processed as HTML tags. Your text makes much better sense when it reads as:
>
>>You might want to use < pre > and < /pre > (remove the embedded spaces to make them work) HTML 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.
>
>
>
>>
>>>>
>>>>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

(On an infant's shirt): Already smarter than Bush