Query to show typed in name, could have duplicates.

[RonnieDobbs]

I am looking to run a query to display's ALL companies with a certain word in it. To clarify, I have criteria which asks for the company name to be dispalyed. If I have names in my table like Blue Inc., Blue Tooth, Blue chemicals, etc.... I want all of these companies to be displayed if I type in blue for my criteria. how would I do this???

thanks,

ab

 

[r937]

... where companyname like '*blue*'

rudy | r937.com | Ask the Expert | Premium SQL Articles
SQL for Database-Driven Web Sites (course starts January 9 2005)

 

[RonnieDobbs]

right, but when the criteria box first pops up I am not going to want to companies that begin with blue every time. I might want to see all companies that begin with "I" or whatever.

 

[r937]

begin with 'I' and contain 'blue' --

... where companyname like 'I*blue*'

rudy | r937.com | Ask the Expert | Premium SQL Articles
SQL for Database-Driven Web Sites (course starts January 9 2005)

 

[RonnieDobbs]

Ok, maybe I am not being that clear. I will try again:

I have a criteria MsgBox that asks a user to enter a company name. I would like the user to be able to enter the first part of the company name, which could be anything. I would like the query to display all copmany names that have whatever the user puts in the box.

if he types in flooring, the query would disply:

flooring INC
Flooring PLC
Flooring unlimited.

 

[r937]

okay, you want whatever is typed in to be at the front of the name, not just anywhere inside it?

... where companyname like 'blue*'

rudy | r937.com | Ask the Expert | Premium SQL Articles
SQL for Database-Driven Web Sites (course starts January 9 2005)

 

[RonnieDobbs]

well, anywhere in it would work too, but based on these replies I need to put this in my company name criteria correct? In that case every time the query is ran, only companies with 'blue*' will be displayed correct?

 

[r937]

no, "blue" was just an example of the value

i don't do access forms but i think you want something like this

... where companyname like [form!].[textbox!] & '*'

rudy | r937.com | Ask the Expert | Premium SQL Articles
SQL for Database-Driven Web Sites (course starts January 9 2005)

 

[PHV]

And if you want a simple parametized query, in the company name criteria:
Like [Enter company name] & '*'


Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244