mattkbishop
Registered User.
- Local time
- Today, 20:03
- Joined
- Mar 5, 2003
- Messages
- 36
Ok. So I finished my project.... but......
I got to show my manager the finish database, feeling pretty pleased with myself. And…
She tells me she needs to be able to multiple search with ease.
So what I’m now looking to do, is to be able to create something, that allows you to search on either a town or/and village, but not just one, many, plus on certain tick boxes, by category with is a subform (multiple categories in one record), and same with age ranges.
Help. It has to be user friendly too...
I think I can set it up in a query to get a pop up box with like:
“Enter town”
then
“Enter Category”
then
“Enter…”
But that’s no good, because if the user wants to search on a number of towns or categories etc on records, I am screwed.
I have no clue how to do this, and my MS Access isn’t that advanced either. Please help. I'm not good with Basic either
I got to show my manager the finish database, feeling pretty pleased with myself. And…
She tells me she needs to be able to multiple search with ease.
So what I’m now looking to do, is to be able to create something, that allows you to search on either a town or/and village, but not just one, many, plus on certain tick boxes, by category with is a subform (multiple categories in one record), and same with age ranges.
Help. It has to be user friendly too...
I think I can set it up in a query to get a pop up box with like:
“Enter town”
then
“Enter Category”
then
“Enter…”
But that’s no good, because if the user wants to search on a number of towns or categories etc on records, I am screwed.
I have no clue how to do this, and my MS Access isn’t that advanced either. Please help. I'm not good with Basic either
