I am trying to build a query form t

[cynaptic]

I am trying to build a query form that searches for a close match, am using the following code, it pops up the parameter prompt but doesn't return any results....

SELECT *
FROM CompanyContacts
WHERE CompanyName LIKE Forms![CompanyContacts]![CompanySearch];

 

[Ninabunny]

If you aren't using a wildcard
SELECT *
FROM CompanyContacts
WHERE CompanyName LIKE Forms![CompanyContacts]![CompanySearch] & "*";

and don't spell or use the correct case it will not return any results. Try that and see if it works!

 

[cynaptic]

Thanks NinaBunny

it works to a degree....

now i get all of the records and no parameter prompt.

help......

 

[cynaptic]

scrap that last - works like a charm. one question though, the * is a wild card for the remainder of the field. how would I introduce a wildcard for the begining of the feild as well i.e. *foo*? As you have probably gathered - I ain't no VB programing wizard....