like statment

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to use the like and "* *" statment within a query.

I know how to use one or the other but not both.

I've tried like "*[]*" but doesn't work

I've tried verious version of this statment but can't find the right
combination
 
Are you saying that you want to find any text string that has a blank space
in it?

Like "* *"

should do that for you.

If you're saying you want to find the text string (literal) "* *", then try
this:

Like "[*] [*]"
 
What you are using is called a "wildcard". Access help has a lot of info on
this. If I had three names "Mills","Milton", "Marton". I would use the
wildcard in this way to bring up those names with this method. "M*". If I
just wanted names ending in "n". I would type "*n". "*" Means any number of
characters before the letter "n" but the last character must be "n". You can
use it in the middle also.
 
Back
Top