I have searched this many times and I have not grasped this idea and I use it a lot. But I struggle every time I change the criteria value.
So I just work around it and have never really fixed it.
Usually I am needing to extract certain IDs. Such as in my SKUs table I may need SkuIDs
Between "0" And "11"
But it returns 1,10,100,1000,10000,10001,
099,11. Done! So I end up with 270 SkuIDs.
I get that in numerical order for Access it is reading left to right and ordering them that way but how do I get this to stop and give me what I want..
I have also used
>0 And <12
Same effects. Thank you for the help.