I was hoping, but no that takes just as long as the previous multi SQL. Thanks guys for helping out. Gotta run.

>Try following trick (it would only work in foxpro)

>    Where ;
>        Upper( Ramp ) = 'CHICAGO'  ;
>    Having ;
>       Between( HourCount, 37, 48 ) And ;
>        Upper( Vendor ) = 'NIKE' ;

>
>>>How long it will it take if you leave only one condition?

Where Upper( Ramp ) = 'CHICAGO'

That's the minimum time you can get for this query.
>>>
>>>>That's true. Please see my reply to Alex Wieder.
>>>>
>>>>>Dan,
>>>< SNIP >
>>
>>I did a select which just did the top select which writes out 27,705 records.
>>I then did another select which applied the rest of the filters.
>>
>>This took 31 seconds.