Searching range for single field: best practice
Hello,
I am wondering what is the best practice for creating a search form that will search a single field for a range?
Specifically, I have a database column for "age." It shows up as an available option for a search page but, I'm not sure how to search that single field for both >= and <=.
DataAssist allows me to add "age" twice, but each time it is called "age" and I don't see a way to edit one as "minimum age" (>=) and the other as maximum age (>=).
What is the best way to search for a range on a single database column?