oscarpompyang
New Member
- Joined
- Jun 25, 2014
- Messages
- 6
Hi, new user here. After scouring the web for help I decided to ask the experts.
I have a database with tagging for each of the entries, and i've set up an advancedfilter macro on it based on user selections. the criteria selection is set up in such a way that users can select multiple options from each of the criteria before they search. the problem is, i belatedly realized that by selecting multiple options, the advancedfilter will show only items tagged to both options in the database. i need it to show the items that are either <option 1> or <option 2>, etc. Is there a way you can suggest for me to go about doing this? I don't want users limited to just one option per criteria per search...
Thanks in advance!
I have a database with tagging for each of the entries, and i've set up an advancedfilter macro on it based on user selections. the criteria selection is set up in such a way that users can select multiple options from each of the criteria before they search. the problem is, i belatedly realized that by selecting multiple options, the advancedfilter will show only items tagged to both options in the database. i need it to show the items that are either <option 1> or <option 2>, etc. Is there a way you can suggest for me to go about doing this? I don't want users limited to just one option per criteria per search...
Thanks in advance!