Hey Walter,

Thanks for the tip. The old FOR - WHILE. I'll definitely give it a try.

>Hi Dan,
>
>IMO, the following be about the fastest way to get the data you want.
>
>

SELECT YourTable
>SET ORDER TO TAG Ramp
>SEEK "CHICAGO"
>COPY FIELDS Ramp, Vendor, VendCity, VendSt, HourCount ;
>     TO TempTable ;
>     FOR Between( HourCount, 37, 48 ) And Upper( Vendor ) = 'NIKE' ;
>     WHILE Ramp="CHICAGO"

>
>I think it would be hard to get any faster than this with a SQL statement.
>
>Walter,