not able to understand wrong result by query

[SKV]

I designed a query to display results in which the zip code (text format) is within a zipcode range in another table. for particular range (see below) I am getting wrong result.
Ex : zip code 60025 is coming between 6000 and 6099.
it is greater than equal to 6000 - OK
It is less than equal to 6099 - NO (but I am still getting this result)

Can you please help me find the issue. I defined all zipcodes as Text as some zipcodes are alphanumneric.

 

[ajetrumpet]

Ex : zip code 60025 is coming between 6000 and 6099.

Might want to read again.

It is less than equal to 6099 - NO (but I am still getting this result)

It is GREATER than 6099.

 

[SKV]

Might want to read again.It is GREATER than 6099.

Yes I know that it is greater, that is why I put NO (logic Output) in the statement

 

[Norie]

Do you realise how Access compares values?

I'm not sure if I can give a thorough explanation but if you are comparing text then it'll be regarded as text, not numbers.

So it will be sorted/filtered alphanumerically not numerically.

That's unless you convert to numbers, and there are plenty of conversion functions in Access.