Wildcard Entry

[aingram]

Help Please

Hi,

Im having a little problem with the following code in one of my queries

Expr1: IIf(IsNull([Forms]![editLookForm]![Company_Name]),True,[Company Name]=[Forms]![editLookForm]![Company_Name])

What this does is, it take an typed entry from the form (editlookform) and seaches for that entry in the query

i want to add wildcard entrys to this so that the person operating doesnt have to know the complete company name - i just dont know where to put them

Help please

 

[MikeChemist]

Hi, Did you ever solve this? I need the same thing. I have a QBF (Query by Form) and I don't know how or where to tell it to accept a * or wildcard entry

 

[EMP]

Expr1: IIf(IsNull([Forms]![editLookForm]![Company_Name]),True,[Company Name] Like "*" & [Forms]![editLookForm]![Company_Name] & "*")

^