Wildcards + Criteria in a table to filter a query

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

Guest

I use wildcards a lot, mainly just the "*" when I am running queries. But I
want to convert this functionality into a more user friendly interface, so
users can enter data in a form and edit the query that way. So I was thinking
I could reference a table field in the criteria row of the query and enter
text and wildcards into the table, but that does not work.

Any suggestions of other ways to go about this?
 
Try entering this in the criteria row:
Like "*" & [Enter some sort of meaningful text here] & "*"
 
Thanks - that was exactly the construction I needed. I know my description
was a little confusing.

Edward G said:
Try entering this in the criteria row:
Like "*" & [Enter some sort of meaningful text here] & "*"
Click to expand...
 
Back
Top