Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Any word selection

0 views
Skip to first unread message

Phyllis

unread,
Jul 1, 2003, 2:43:20 PM7/1/03
to
What am I doing wrong. I am attempting to create a video
library and I want to be able to search the database by
Actor/Actress, or movie title and would like to be able to
retrieve a record that I may only know the first name or
even a partial movie title. Did I do something wrong in my
tables. I have a field called Cast Name and a field called
Movie Title. Self teaching is tough! LOL

Phyllis

Sal Rosario

unread,
Jul 1, 2003, 3:06:10 PM7/1/03
to
You can do this for the criteria row of the movie title:
LIKE [Enter movie title]
That will allow you to use * to replace what you don't know. For example,
Ram*. That will give you Rambo 1 through 20 for sure!

Sal
www.cedrostec.com

"Phyllis" <pkat...@sympatico.ca> wrote in message
news:33a201c34000$a4d9f130$a601...@phx.gbl...

Lance

unread,
Jul 1, 2003, 3:10:06 PM7/1/03
to
When you are searching you may want to add a * to end of
your search string (e.g. Monr*)

>.
>

Phyllis

unread,
Jul 1, 2003, 4:09:38 PM7/1/03
to
I put Like [Enter movie or patial using space *] and only
the first word of a movie is found. For example the
movie "Full Metal Jacket" with this criteria it works if I
type in Full * but if I put in Jacket * nothing shows up.
A asterick only works when followed by the word and a
space then the *.

Phyllis

>.
>

Chris Strug

unread,
Jul 2, 2003, 4:25:09 AM7/2/03
to

"Phyllis" <pkat...@sympatico.ca> wrote in message
news:387b01c3400c$b34032a0$a401...@phx.gbl...

> I put Like [Enter movie or patial using space *] and only
> the first word of a movie is found. For example the
> movie "Full Metal Jacket" with this criteria it works if I
> type in Full * but if I put in Jacket * nothing shows up.
> A asterick only works when followed by the word and a
> space then the *.
>
> Phyllis
>

The "*" character is what is known as a wilcard in that it will match one or
more of any characters in the string that it is entered.

For example, Ram* will give you 'Rambo', 'Rambus', etc. In your example,
Access thinks that "Jacket" is the start of the string, so it would find
"Jackets of Hell" but not "Full Metal Jacket".

IIRC putting a "*" before Jacket will give you movie titles containing the
string Jacket anywhere in the title.

E.g. "*Jacket*", will give you "Full Metal Jacket". Also, be aware of the
the space. "* Jacket *" is different to "*Jacket*".

You may also want to look up the '?' wilcard in Access help.

Hope this helps

Chris Strug


Bananas

unread,
Jul 4, 2003, 5:17:47 PM7/4/03
to

"Phyllis" <pkat...@sympatico.ca> schreef in bericht
news:33a201c34000$a4d9f130$a601...@phx.gbl...
Try this

Insert this command as a criteria

Like '%' & [question] & '%' Rem "This is for Excell (MS-Query)

Like "*" & [question] & "*" Rem "This is for Access Query

0 new messages