Hello I have recently started to use access and have came into some difficulty with one query in particular.

I am trying to create a query where the user can type in part of a product name and then be shown all of the matches.

So far this is what i have in the critera box

[Enter Product name: ]

I ahve tried the Wildcard * in as many places as I could think of and none would give the required result.

Sorry if my message is not very clear I am pretty new to access. If you need any more information please ask.

Thanks !

I am trying to create a query where the user can type in part of a product name and then be shown all of the matches.

So far this is what i have in the critera box

[Enter Product name: ]
!

i wrote a faq for this. search forum for thread titled "using wildcards in queries".

also, the syntax you probably want to get it done is:WHERE [product field] =

"*" & [enter product name: ] & "*"

WHERE [product field] =

"*" & [enter product name: ] & "*"

Except that you'd want to use Like rather than =.

Except that you'd want to use Like rather than =.

laughing... :rolleyes:

laughing... :rolleyes:
Was that a sarcastic laugh ajetrumpet? I am yet to see one of those ;)

Was that a sarcastic laugh ajetrumpet? I am yet to see one of those ;)

the name is adam. okie dokie? :)

and no...it's sort of a "why do I have to be perfect all the time?" laugh. shouldn't the OP be able to assume that I meant to write "LIKE" instead of "="!?!? :D

I could've told him to try this query instead:$sql = "SELECT whatever

FROM table

WHERE productfield LIKE '%parameter%'";

mysql_query($sql);;) ;) I'm sure by now, this guy is thinking we're half crazy

the name is adam. okie dokie? :)Comprend é :)


and no...it's sort of a "why do I have to be perfect all the time?" laugh. shouldn't the OP be able to assume that I meant to write "LIKE" instead of "="!?!? :D

I could've told him to try this query instead:$sql = "SELECT whatever

FROM table

WHERE productfield LIKE '%parameter%'";

mysql_query($sql);;)Keeping up the high standards the forum demands Adam. Shoot for the stars haha!!:D

;) ;) I'm sure by now, this guy is thinking we're half crazy :)He will think, "what a lovely thread I created"

I always wonder why your tags are always in PHP:confused:

shouldn't the OP be able to assume that I meant to write "LIKE" instead of "="!?!?

Depends on the OP. Given that this one just joined and has 2 posts, there's a strong possibility they don't know about Like.

they don't know about Like.

yeah but do they know about the healthcare summit? :D:D

i wrote a faq for this. search forum for thread titled "using wildcards in queries".

also, the syntax you probably want to get it done is:WHERE [product field] =

"*" & [enter product name: ] & "*"

Haha lol, no you guys are right I really don't have a clue about access. Just starting of this week really. Thanks for the help so far guys. I tried to type this into the criteria box, am I right in doing that?

Hopefully this example will help a bit. I have a product name of say "Hampton Lamp Table" there are also "Hampton Coffee Table" and other pieces in that range. I also will have other ranges such as Aspen in my Table. I would like a query so that if I type in Hampton then all pieces of Hampton will come up regardless of their full name. The queries that I am building so far only seem to be able to bring up the product when the full name is typed in.

Thanks very much for the help so far!

This is what was suggested to be put in the Criteria box:

Like '*" & [Enter Product name: ] & "*'

Thanks very much guys you have been Great!

Glad it worked for you. I hope you were also entertained too! :)

Haha yes, this seems like a pretty good forum!

It sure is Exoduslow. Just stop by anytime and post a thread if you get stuck on matters covered on this Forum.

Have fun developing your db.

Thanks very much mate, I am actually working on it at the moment. :)