Wildcards + Criteria in a table to filter a query

[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?

 

[Steve Schapel]

Beverly,

Can you give an example please?

 

[Edward G]

Try entering this in the criteria row:
Like "*" & [Enter some sort of meaningful text here] & "*"

 

[Guest]

Thanks - that was exactly the construction I needed. I know my description
was a little confusing.

Try entering this in the criteria row:
Like "*" & [Enter some sort of meaningful text here] & "*"