Hi Bruce,
Thish shouldn’t be too complicated, but I’m not sure you know that in this case only results exactly matching the price would be returned. Since the values are stored in a ‘R40,000’ format, it’s considered as text by the database, and operators like ‘lower than’ and ‘greater than’ will not work at all – only the LIKE text operator.
If that’s okay with you, I might be able to suggest a solution.