Oh, yes - not reading the SQL fully enough :-)
Thanks
>Terry,
>
>The sort order is DESCending.
>>
>>Could you please clarify for me how your soln. gets the LAST 1000 recs? I'd've thought that this would get the FIRST 1000 recs in the criteria.
>>
>>Terry
>>
>>>
select TOP 1000 unemp_ins_pct from payroll_tbl ;
>>> where unemp_ins_pct # 0 ;
>>> into array a__gen40 ;
>>> order by payroll_tbl.id DESC
- Whoever said that women are the weaker sex never tried to wrest the bedclothes off one in the middle of the night
- Worry is the interest you pay, in advance, for a loan that you may never need to take out.