Parameter Query using Like

  • Thread starter Thread starter Don Hicks
  • Start date Start date
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
 
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
 
Hi,


Syntax. Try


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


Hoping it may help,
Vanderghast, Access MVP
 
Hi,


Syntax. Try


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


Hoping it may help,
Vanderghast, Access MVP
 
Back
Top