I want to create a query in msaccess(in the design view). I want the query to display numbers 4-7 only.
Now in the criteria box I've tried "4"-"7" and I tried Between #4#-#7#.
But neither of those worked does anyone know how to create a query in the design view that will display only numbers between 4 and 7