query syntax

B

brian

Hello. I am using a button on a form to launch a query
that includes data from a text box on the form itself.
What I need to do is prepend a wildcard so that the query
includes it in the search.

What else do I need in the criteria box?

Like Forms![frm1]![txt1]

Thanks!
 
B

brian

That did it. Thanks!
-----Original Message-----
Try;

Like '*' & Forms![frm1]![txt1] & '*'

Steve.

-----Original Message-----
Hello. I am using a button on a form to launch a query
that includes data from a text box on the form itself.
What I need to do is prepend a wildcard so that the query
includes it in the search.

What else do I need in the criteria box?

Like Forms![frm1]![txt1]

Thanks!
.
Click to expand...
.
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access automatically changes name of form in conditional query 1
Multiple Parameter Crosstab query filter by form 1
Change query criteria by form with wildcards 6
Muliple Critera 1
Access Dcount (multiple criteria) 3
Access Access Report Works on One Machine but not Another 3
Using the like operator with input data 2
use field list from form to specify query fields 2

Top