Wild Card in response

  • Thread starter Thread starter Glenda
  • Start date Start date
G

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"?
 
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"?
Click to expand...

Use a criterion of

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

If [Title?] is the parameter, and the user would enter "happy", then in your
critera, use this:
Like "*" & [Title?] & "*"
 
wow, in a million years I wouldn't have thought of this... thank you both
--
Glenda


John W. Vinson said:
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"?
Click to expand...

Use a criterion of

LIKE "*" & [Title?] & "*"
Click to expand...
 
in a million years I wouldn't have thought of this, thank you
--
Glenda


Daryl S said:
Glenda -

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

--
Daryl S


Glenda said:
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"?
Click to expand...
Click to expand...
 
Back
Top