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,