Access Query - find records less than or greater than input criteria

[Bazza66]

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.

 

[BlueHorizon]

Hi Bazza66,
You may want to post this in one of the Access forums.



Best,
Blue Horizon

http://www.bluehorizontraining.com

 

[RivetHed]

Hi Bazza, try setting your criteria as abs([Myfield]) > [Input Variance]