MS Access 2002 Expression Help!

[daviddenver303]

I have a simple database that I have build in MS Access 2002. It is a database containing some company names, addresses, etc.

I have built a query and want to be able to search by a company name. I want the query to open a box and ask the user to input the company name OR part of the company name and have the query display records that match OR partially match.

I know when building a query, I can use [Company] in the "Criteria" and the message box will come up and ask the user to type in the Company Name. In this instance, the user must type the Company Name EXACT or it won't pull up the company.

I also know how to use the "LIKE" command to search for records that are like a certain name.

I just need to know what expression I would use to 1) open the box and ask the user to input the company name and then use the "LIKE" to search for similar records.

Anyone know an expression for something like this???

Thanks,
David

 

[mdthornton]

Try this in your criteria line:

like [Enter Company: ] + "*"

to match companies starting with the string entered or:

like "*" + [Enter Company: ] + "*"

to match the string anywhere in the company string. If a full name is entered it should still work Best Regards,
Mike

 

[daviddenver303]

Mike, that is EXACTLY what I was looking for!

Thank you so much!

David