Greater than query

[noobaccess]

Hi all,



i am facing this problem that i cant understand why it actually appear it this way.

i am trying to display records that are above 40, so i use a >40 in my query, however it does not show the records that are all more than 40, it shows records that are less than 40. I have a query that is <40 it is working fine, so i cant understand what the problem is. The inputs have numbers like 50-100, 40-50. Is that the reason why it couldnt work?

Can someone help?

Attach is my records that i get when i search for items > 40.

thanks in advance!

[pbaldy]

Your problem is that your field is text, so you're getting an alphabetic comparison. I would use one or two numeric fields, depending on what those numbers represent.

[noobaccess]

if i change it to numeric field, i wont be able to enter strings like 5-10, 10-20 am i correct?

i actually want to set it as a range like from 5-10 and when i click on "below 10" in my combo box, it should appear in my result, is it possible to do that?

[pbaldy]

I don't understand the data, but "5-10" isn't a price point, it's a range. That's why I was thinking two fields, for the upper and lower boundaries.

[John_G]

Hi -

If you are using a query, and you want to specify a range, use BETWEEN. For example, 5 - 10 would be expressed as between 5 and 10, and can be used in query criteria. It becomes part of the WHERE clause - use the SQL View of a query to see the syntax.

You will have to change your field data type to numeric.

HTH

John

[noobaccess]

oh okay! i understand better now! Many many thanks!!!!!!