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

G

Gingertrees

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
 
F

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
Click to expand...

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

Gingertrees

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

fredg said:
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
Click to expand...

As criteria in the BookTitle column, use:
Like "*" & [Enter part of title] & "*"
Click to expand...
 
Top