>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.