PDA

Click to See Complete Forum and Search --> : Access Query's (easy)


cid
Nov 4th, 2003, 03:42 PM
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

D12Bit
Nov 4th, 2003, 09:00 PM
in the filter select the field with the value and type:
>=4 And <=7

that's it