Web Development

Ask something
Question Locked

Microsoft Access Query

0 helpful
2 replies

by jeremy.thornber

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Please help! I have a query in access which does not return the right result and I'm at a complete loss as to why?
The query is to only display numbers which are >0 And <5, however any number over 9 i.e two digits seems to be displayed also?
I have tried >0 And <05 but this means all numbers between zero and 5 get shown in another query which is >07 Any suggestions would be gratefully recieved!

2 replies

by shellbot

if your col is number, should return ok, however, if your col is text it will return incorrectly.
I did a quick test, in that secenario i got 1, 2, 3, 4, 10, 11 returned :)

This discussion is closed to new replies.