Web Development
When I write my query in Access >0 And <5 any number over 9 appears in also. Is there a way to prevent this without putting a leading 0 there, as that means when I get to my last query of >7 written as >07 all numbers appear?
Hope this makes sense.
by jeremy.thornber Accepted solution
by midniteone Accepted solution
been trying to replicate your problem on a simple 1-11 with 2 fields and can't get it to do so - just typed in expression, exactly as you have, under criteria in query design view.
only thing occurs to me is if it's doing a text sort hence 11, 111, 1111 get in also but would have thought this should have thrown a data type error. would have sent me back to table design view to check type though.
sorry, not being much help here but I must admit only been mangling access for a few months with two days training and a 'for dummies' book so nowhere near an expert!
will watch for the right answer!
This discussion is closed to new replies.
Sort by Trending