Wild Card in response

[Glenda]

In a report / Query, I'd like for the database to recognize all inputs that
are similar to the field. In the Query I am putting [Title?]. What do I
need to add so the responses will e.g. include all titles that include the
word "happy"?

 

[John W. Vinson]

In a report / Query, I'd like for the database to recognize all inputs that
are similar to the field. In the Query I am putting [Title?]. What do I
need to add so the responses will e.g. include all titles that include the
word "happy"?

Use a criterion of

LIKE "*" & [Title?] & "*"

 

[Daryl S]

Glenda -

If [Title?] is the parameter, and the user would enter "happy", then in your
critera, use this:
Like "*" & [Title?] & "*"

 

[Glenda]

wow, in a million years I wouldn't have thought of this... thank you both
--
Glenda

In a report / Query, I'd like for the database to recognize all inputs that
are similar to the field. In the Query I am putting [Title?]. What do I
need to add so the responses will e.g. include all titles that include the
word "happy"?

Use a criterion of

LIKE "*" & [Title?] & "*"

 

[Glenda]

in a million years I wouldn't have thought of this, thank you
--
Glenda

Glenda -

If [Title?] is the parameter, and the user would enter "happy", then in your
critera, use this:
Like "*" & [Title?] & "*"

--
Daryl S

In a report / Query, I'd like for the database to recognize all inputs that
are similar to the field. In the Query I am putting [Title?]. What do I
need to add so the responses will e.g. include all titles that include the
word "happy"?