Is it possible to create a Parameter query to search multiple fields for the same term.
For example:
A decorator database captures color choice in a first, second, and third choice (3 separate fields). So "Green" could appear in any one of the three fields.
I would like to create a query that can prompt the user to enter a color "[Enter color choice]" once that will search all three fields for the choice.
I know I could do this by entering the parameter on each choice on a different criteria row in Design, but that would then prompt the user to enter the choice three times.
Is there a cleaner way to do it?
Is there a way to query "Choice1" OR "Choice2" OR "Choice3" using a single "[enter choice]"?