051119 Posted January 10, 2010 Share Posted January 10, 2010 I have a query which throws up a number, and I want to find values that fall within that number, plus 200. Basically, if the query throws up 1000, I'm after 800 to 1200. I've tried adding Between ([Query]![Val1]-200) And ([Query]![Val1]+200))); to the bottom of a query with no success. I honestly can't think of any other way to do this. Does anyone have any ideas? Link to comment https://forums.phpfreaks.com/topic/187956-find-withinbetween-two-values/ Share on other sites More sharing options...
051119 Posted January 10, 2010 Author Share Posted January 10, 2010 Sorry, I've been a nitwit and found a better way of solving my problem! Link to comment https://forums.phpfreaks.com/topic/187956-find-withinbetween-two-values/#findComment-992353 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.