Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations MikeeOK on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Find records less than or greater than in list
I am trying to filter records in a query that are less than or greater than one input field. For instance I have numbers from -100 to 100 and I want to be able to select all records above 50 or below -50. I can do this using <-50 or >50 but I want to prompt the user to input this value as it may...- Bazza66
- Thread
- Replies: 1
- Forum: Microsoft: Access Queries and JET SQL
-
Access Query - find records less than or greater than input criteria
I am trying to filter records in a query that are less than or greater than one input field. For instance I have numbers from -100 to 100 and I want to be able to select all records above 50 or below -50. I can do this using <-50 or >50 but I want to prompt the user to input this value as it may...- Bazza66
- Thread
- Replies: 2
- Forum: Microsoft: Office
