Microsoft Access Query - TechRepublic
Question
May 31, 2007 at 01:11 AM
jeremy.thornber

Microsoft Access Query

by jeremy.thornber . Updated 19 years, 1 month ago

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!

This discussion is locked

All Comments