G Guest Aug 30, 2006 #1 how can i use the greater than or less than symbols in a query so that i can find a certain range of numbers?
how can i use the greater than or less than symbols in a query so that i can find a certain range of numbers?
R Roger Carlson Aug 30, 2006 #2 Use the Between function instead: Ex. Between 5 And 10 Between #1/1/2006# And #5/1/2006# The Between function is inclusive, meaning the values in the function are included in the results. -- --Roger Carlson MS Access MVP Access Database Samples: www.rogersaccesslibrary.com Want answers to your Access questions in your Email? Free subscription: http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L
Use the Between function instead: Ex. Between 5 And 10 Between #1/1/2006# And #5/1/2006# The Between function is inclusive, meaning the values in the function are included in the results. -- --Roger Carlson MS Access MVP Access Database Samples: www.rogersaccesslibrary.com Want answers to your Access questions in your Email? Free subscription: http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L
D Duane Hookom Aug 30, 2006 #3 Open the query in Design View and find the Criteria row under the field/column where you want to set the filter. Enter something like <30 or Date() Click to expand... or <="A" or Between Date()-30 And Date()
Open the query in Design View and find the Criteria row under the field/column where you want to set the filter. Enter something like <30 or Date() Click to expand... or <="A" or Between Date()-30 And Date()
F fredg Aug 30, 2006 #4 how can i use the greater than or less than symbols in a query so that i can find a certain range of numbers? Click to expand... To find values between 5 and 10 using < and > Where YourTable.NumberField > 4 and YourTable.Numberfield <11 To find values between 5 and 9 Where YourTable.NumberField >=5 and YourTable.Numberfield <10 To find values between 6 and 10 Where YourTable.NumberField >5 and YourTable.Numberfield <=10 Of course, to find values between 5 and 10 inclusive, you could simply use: Where YourTable.NumberField Between 5 and 10
how can i use the greater than or less than symbols in a query so that i can find a certain range of numbers? Click to expand... To find values between 5 and 10 using < and > Where YourTable.NumberField > 4 and YourTable.Numberfield <11 To find values between 5 and 9 Where YourTable.NumberField >=5 and YourTable.Numberfield <10 To find values between 6 and 10 Where YourTable.NumberField >5 and YourTable.Numberfield <=10 Of course, to find values between 5 and 10 inclusive, you could simply use: Where YourTable.NumberField Between 5 and 10
