Is it possible to have a search on several specific fields with an OR function rather than the default AND
eg,
Field 1 = A
Field 2 = B
I want to be able to search for a results that has either field 1 as A OR field 2 = A, but no record will ever have field 1 = A AND field 2 = A - if that makes any sense.
I then need to make several other standard AND searches within the same form.
eg,
Field 1 = A
Field 2 = B
I want to be able to search for a results that has either field 1 as A OR field 2 = A, but no record will ever have field 1 = A AND field 2 = A - if that makes any sense.
I then need to make several other standard AND searches within the same form.