Quieries Criteria Question

  • Thread starter Thread starter Jason
  • Start date Start date
J

Jason

In Design View under my "Company's Name" column, I have
entered [Please Enter Company's Name] in the criteria
field. I would like the program to return any companies
that contrain what the user responds.

For Example:
Please Enter Company's Name? They type "XYZ"
and the program will return results that contain "XYZ" in
the company name field. Such as "XYZ Express" "Pinical
XYZ" and "The XYZ Co.".
Thanks!
 
you need....


LIKE "*" & [Please Enter Company Name] & "*"



Rick B


In Design View under my "Company's Name" column, I have
entered [Please Enter Company's Name] in the criteria
field. I would like the program to return any companies
that contrain what the user responds.

For Example:
Please Enter Company's Name? They type "XYZ"
and the program will return results that contain "XYZ" in
the company name field. Such as "XYZ Express" "Pinical
XYZ" and "The XYZ Co.".
Thanks!
 
Gary:

Enter the following in the criteria cell of the Company's Name column.

Like "*" & [Please Enter Company's Name] & "*"

--Wesley

*Any program that works, is better than any program that doesn't.
--Gerald Weinberg; The Psychology of Programming


Gary said:
Try: Like * & [Please Enter Company's Name] & *
-----Original Message-----
In Design View under my "Company's Name" column, I have
entered [Please Enter Company's Name] in the criteria
field. I would like the program to return any companies
that contrain what the user responds.

For Example:
Please Enter Company's Name? They type "XYZ"
and the program will return results that contain "XYZ" in
the company name field. Such as "XYZ Express" "Pinical
XYZ" and "The XYZ Co.".
Thanks!

.
Click to expand...
Click to expand...
 
Back
Top