Parameter Query using Like

D

Don Hicks

Hello,

In an Access 97 database, I'd like to query a table (called "Vendors")
having a prompt ask me for the pertinent data each time.

For instance, I'd like to get a list of all vendors with the word, "Office"
in their company name. Usually, I'd write a query with a condition reading,
LIKE "*OFFICE*".

But, I'd like this query to give me a prompt asking for the search criteria.

I've tried writing a condition reading, LIKE "*[Enter Key word in Vendor
Name:]*", but this kind of query doesn't seem to work.

Can anyone help me out?

Sincerely,
Don Hicks
Portland, OR
 
D

Dennis Schmidt

Hi Don,

My name is Dennis Schmidt. Thank you for using the Microsoft Newsgroups.

I hope this helps! If you have additional questions on this topic, please
reply to this posting.

Use a syntax similar to the following:

Like "*" & [YourMessage] & "*"

Need quick answers to questions like these? The Microsoft Knowledge Base
provides a wealth of information that you can use to troubleshoot a problem
or answer a question! It's located at
http://support.microsoft.com/support/c.asp?M=F>.

This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use. © 2001 Microsoft Corporation. All rights
reserved.

Regards,
Dennis Schmidt
Microsoft Support
 
M

Michel Walsh

Hi,


Syntax. Try


LIKE "*" & [ enter key word in vendor name: ] & "*"


Hoping it may help,
Vanderghast, Access MVP
 
M

Michel Walsh

Hi,


Syntax. Try


LIKE "*" & [ enter key word in vendor name: ] & "*"


Hoping it may help,
Vanderghast, Access MVP
 
Top