my goal is to create a conflict check programs. I have 5 parameter values which are just keywords and also a group parameter, so i am scanning all the keywords for each idividual field. the problem i have with my code is that once the first field is an empty string, the report stops filtering the data.
here is the function:

Function (stringVar name1, stringVar field, stringVar name2, stringVar name3, stringVar name4, stringVar name5)
if
(
name1 in field and
name1 <> "" or
name2 in field and
name2 <> "" or
name3 in field and
name3 <> "" or
name4 in field and
name4 <> "" or
name5 in field and
name5 <> ""
)
then totext (field)

here is the formula: (for each field, i have written a search formula)
Search ({?Name1} ,{TBL_GROUP.CUST_P1a_AttyName_021312192} ,{?Name2} ,{?Name3},{?Name4},{?Name5} )

here is the filter:
{CUST_CustomTable2_021344.CUST_NeutralName_0214018 64} = {?NeutralName} and
({@Referring} <> ""
or {@Groupname} <> ""
or {@ContactFullname} <> ""
or {@ContactLawfirm} <> ""
or {@P1a_attyName} <> ""
or {@P1b_attyName} <> ""
or {@P1c_attyName} <> ""
or {@P1d_attyName} <> ""
or {@P1e_attyName} <> ""
or {@P1f_attyName} <> ""
or {@P1g_attyName} <> ""
or {@P1h_attyName} <> ""
or {@P1i_attyName} <> ""
or {@P1j_attyName} <> ""
or {@P2a_attyName} <> ""
or {@P2b_attyName} <> ""
or {@P2c_attyName} <> ""
or {@P2d_attyName} <> ""
or {@P2e_attyName} <> ""
or {@P2f_attyName} <> ""
or {@P2g_attyName} <> ""
or {@P2h_attyName} <> ""
or {@P2i_attyName} <> ""
or {@P2j_attyName} <> ""
or {@P1a_lawfirm} <> ""
or {@P1b_lawfirm} <> ""
or {@P1c_lawfirm} <> ""
or {@P1d_lawfirm} <> ""
or {@P1e_lawfirm} <> ""
or {@P1f_lawfirm} <> ""
or {@P1g_lawfirm} <> ""
or {@P1h_lawfirm} <> ""
or {@P1i_lawfirm} <> ""
or {@P1j_lawfirm} <> ""
or {@P2a_lawfirm} <> ""
or {@P2b_lawfirm} <> ""
or {@P2c_lawfirm} <> ""
or {@P2d_lawfirm} <> ""
or {@P2e_lawfirm} <> ""
or {@P2f_lawfirm} <> ""
or {@P2g_lawfirm} <> ""
or {@P2h_lawfirm} <> ""
or {@P2i_lawfirm} <> ""
or {@P2j_lawfirm} <> ""
or {@P1a_party} <> ""
or {@P1b_party} <> ""
or {@P1c_party} <> ""
or {@P1d_party} <> ""
or {@P1e_party} <> ""
or {@P1f_party} <> ""
or {@P1g_party} <> ""
or {@P1h_party} <> ""
or {@P1i_party} <> ""
or {@P1j_party} <> ""
or {@P2a_party} <> ""
or {@P2b_party} <> ""
or {@P2c_party} <> ""
or {@P2d_party} <> ""
or {@P2e_party} <> ""
or {@P2f_party} <> ""
or {@P2g_party} <> ""
or {@P2h_party} <> ""
or {@P2i_party} <> ""
or {@P2j_party} <> "")

i guess the question really is, is it possible to sort/filter through an entire table or setup the function or formula to read the table and not each field?
either through a case statement or a do while statement? thx