Partial data search in a column

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi, I'm just trying to create a simple search field for every field that I
have in a lengthy table. I have created these search fields in a Query and it
produces output records only if the complete data in one of the cells is
input in the criteria. I can't get any outputs if I just feed in part data of
a cell through the criteria.
eg:cell: IR700
criteria: "IR7"
output : blank
Can someone please help?
Thanks
 
For start of field --
Like [Enter start] & "*"

For end of field --
Like "*" & [Enter start]

For any pert of field --
Like "*" & [Enter start] & "*"
 
Back
Top