query for table issues

[IT_Charlies]

Hello i am a novice to Access databasing

i am running an Access 2000 database on Access 2010. (not sure if this would cause a conflict)

i need create a query for a table containing 1,372,433 records. on this query i want to get only the records which values are equal to and or grater than 125,000. on the design view of the query on the field containing the values, under criteria i type:
( >"125000" )
however when i run the query i still get amounts less than 125,000 that start with 125XX or 126XX etc.
on top of the values i also need to sort them by zipcodes.



so what i need is to get a table which values are greater than or equal to 125,000 and certain zipcodes.
how can i manage that?

if u need more information or have questions let me know please.
thank you in advance for your help and/or suggestions, ITC.

[pbaldy]

It sounds like the field is text rather than numeric (the data type). If so, you're going to get alphabetic sorting rather than numeric. My first option would be to change the data type. If not possible, this may work:

SELECT...
FROM...
WHERE CLng(FieldName) > 125000