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 change. When I start using [Input Variance] the calculation <(0-[Input Variance]) OR >[Input Variance] does not work nor does anything else I have tried. I am using a select query. Thanks for any help, Andy.
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
- Thread starter Bazza66
- Start date
- Status
Similar threads
- Question
- Locked
- Question
- Locked
- Question
- Locked
- Question