Originally Posted by
June7
Okay, little more complicated but maybe this is it:
Is your data actually single character in each field? Have a textbox on form that concatenates all 4 fields as a single string.
Then the search query is:
SELECT JobNumber, Item1, Item2, Item3, Item4
FROM Table1
WHERE (((IIf(Not IsNull([Item1]),IIf(InStr([Forms]![Form1]![Items],[Item1])>0,"Y","N"),Null) & IIf(Not IsNull([Item2]),IIf(InStr([Forms]![Form1]![Items],[Item2])>0,"Y","N"),Null) & IIf(Not IsNull([Item3]),IIf(InStr([Forms]![Form1]![Items],[Item3])>0,"Y","N"),Null) & IIf(Not IsNull([Item4]),IIf(InStr([Forms]![Form1]![Items],[Item4])>0,"Y","N"),Null)) Not Like "*N*"));