ive got a database with computer details within it. i need to run a query upon all the compters mhz speed. but when i make a query for example less than 500mhz it displays all pc's with less than 500mhz and all the pc's with more than 1000mhz. how can i eliminate all the pc's with more than 1000mhz.

Thanks for your Help

Rob