Criteria in query is greater than or equal to 15% but it gave values less than 15%!y?

[nofeara]

same as the title goes, why i can't query those figures greater than 15% only? How am i suppose to query them right?.Here is my database you cant check query1 and query 2. I am using Ms Access 2010.

Link:

www dot dropbox dot com/s/n3iuev1c5e0dfby/StockMonitoring.accdb

sorry i can't link up to now

xD: View attachment StockMonitoring.zip
Hope someone help me.

 

[JHB]

Because you are comparing text and numbers!
Your table field is text type.

 

[nofeara]

Because you are comparing text and numbers!
Your table field is text type.

thanks for the reply.

well actually, when i changed it to number it won't return anything. and then how bout the "qryStockStatusSuccessPicks" is something wrong with the criteria under SPL%change?

i would actually like to query stocks price difference above or equal to based on my tblSuccessPercentage. But kinda stock with that percentage thing.

 

[JHB]

One thing more, in the table "tblSuccessPercentage" is the field "tblSuccessPercentageInput" format as percent.
I have attached the database.

 

[nofeara]

One thing more, in the table "tblSuccessPercentage" is the field "tblSuccessPercentageInput" format as percent.
I have attached the database.

Yes it is. oh ok now if i did not format them to percent it was fine. Thank you very much.))(i guess solved now)

BUT, why was it not functioning well when they are formatted to %?

 

[JHB]

BUT, why was it not functioning well when they are formatted to %?

I think it was function ok - remember 15% = 0,15 decimal, so return value of 2,08 is correct because it is more as 0,15.