Hello, as the title suggests I want to be able to have my form that is made to search for real estate and have a minimum threshold to bring back results.
IE: If a person wants to search for red houses but there are only 4 in the entire county I want it to kick it back with a minimum threshold not being satisfied because my arbitrary number might be 5 results to make a general consensus on houses in that market.
The same thing for a return for only the top 1/3th of results of the same kind of form.
IE: if the results bring back 15 results I want it to eliminate 2/3rds of the results to show the top end of the market. It can be tied together so that it has to be 1/3th and also be more than 5.
I hope that makes sense and thank you in advance for any advice, I am an Access novice and haven't worked with it extensively since high school back in the early 00's.