search for "Skip", "Dog" get "My Dog Skip"

[Guest]

In my library database, I built a query to search for books by title.
Unfortunately, you have to type the whole title or the FIRST WORD * to get
any results.

Here's what I'd like: If I'm looking for the book "My Dog Skip", I want that
title to pop up whenever I enter "Skip", "Dog", "My Dog", etc.

I'm sure someone on this board is smarter than me...
~G

 

[fredg]

In my library database, I built a query to search for books by title.
Unfortunately, you have to type the whole title or the FIRST WORD * to get
any results.

Here's what I'd like: If I'm looking for the book "My Dog Skip", I want that
title to pop up whenever I enter "Skip", "Dog", "My Dog", etc.

I'm sure someone on this board is smarter than me...
~G

As criteria in the BookTitle column, use:
Like "*" & [Enter part of title] & "*"

 

[Guest]

Look in Access Help for the LIKE operator

Dorian

 

[Guest]

Thanks! I knew it had to be some combo of Like and *, I just had the wrong
syntax.
~G

In my library database, I built a query to search for books by title.
Unfortunately, you have to type the whole title or the FIRST WORD * to get
any results.

Here's what I'd like: If I'm looking for the book "My Dog Skip", I want that
title to pop up whenever I enter "Skip", "Dog", "My Dog", etc.

I'm sure someone on this board is smarter than me...
~G

As criteria in the BookTitle column, use:
Like "*" & [Enter part of title] & "*"