Begginer needs help

[XXXXThornber]

Please help! I have a very simple numeric query for my DB which is to display >0 And <5 however anything over the value of 9 is also displayed as a result. I have tried with a leading zero but this just means that my last query becomes >07 and this then displays all numbers????
I'm sure it's something very simple but please help!!!!

 

[milos111]

Check table data types

First check your table and data type (data type should be set as number, otherwise you can get results similar to yours.
Second, in your query, put in your criteria field this: between 0 and 5
or use >0 and <5 -both work well.