Use of Wildcard in String Expression

  • Thread starter Thread starter NEWER USER
  • Start date Start date
N

NEWER USER

I am trying to get the wildcard syntax "*" correct on the query grid in the
following and have struggled. Any help appreciated.

InStr([Enter Food Product(s)],[Food Group])

Criteria is >0

Instead of typing Milk,Butter,Bread,Lettuce when prompted in the Parameter
Value

I would like to be able to type Mi, Bu,Br,Le. Can this be accomplished?
 
In the

In the criteria for the proper field:

Like "*" & [Enter Food Product] & "*"

The above will find BU anywhere in the string. If you want it to start with
BU:

Like [Enter Food Product] & "*"
 
Since INSTR does not use wildcards I don't see how your question applies.

You might be able to use something like the following if you wanted to match
on just two characters.

InStr([Enter Food Product(s)], Left([Food Group],2))



John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
 
That works for well for searching one value. What if I want to return Milk
or Bread ? I get an empty string when doing so. This is why I was using
InStr and separating values with a comma (milk,bread). My users may not
spell correctly so I wanted a wildcard to minimize/avoid spelling errors.
Any other suggestions with wildcard and InStr function?

Jerry Whittle said:
In the

In the criteria for the proper field:

Like "*" & [Enter Food Product] & "*"

The above will find BU anywhere in the string. If you want it to start with
BU:

Like [Enter Food Product] & "*"
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.


NEWER USER said:
I am trying to get the wildcard syntax "*" correct on the query grid in the
following and have struggled. Any help appreciated.

InStr([Enter Food Product(s)],[Food Group])

Criteria is >0

Instead of typing Milk,Butter,Bread,Lettuce when prompted in the Parameter
Value

I would like to be able to type Mi, Bu,Br,Le. Can this be accomplished?
Click to expand...
Click to expand...
 
You answered my question. No wildcards allowed in INSTR

John Spencer said:
Since INSTR does not use wildcards I don't see how your question applies.

You might be able to use something like the following if you wanted to match
on just two characters.

InStr([Enter Food Product(s)], Left([Food Group],2))



John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County

NEWER said:
I am trying to get the wildcard syntax "*" correct on the query grid in the
following and have struggled. Any help appreciated.

InStr([Enter Food Product(s)],[Food Group])

Criteria is >0

Instead of typing Milk,Butter,Bread,Lettuce when prompted in the Parameter
Value

I would like to be able to type Mi, Bu,Br,Le. Can this be accomplished?
Click to expand...
.
Click to expand...
 
Back
Top