So, I know this question pops up a lot, but I still can't seem to find my answer in the haystack.
I am building a Self Storage database for a customer.
Now, when the employees of the Self Storage database gets a customer, I would like them to enter a desired number interval, say 3-5, to list all vacant storage rooms with 3-5 square feet of space for rental.
Although when I try this, I don't get the desired result, actually I don't get any result at all.
- Please see attached images.
I even tried altering the relationship like written below, since I would assume this would list all possible storage rooms, but with no luck:
CUS_ListUnits__gxn ≥ UnitSquareMeters
CUS_ListUnits__gxn ≤ UnitSquareMeters
Help is needed and much appreciated.