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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Gingertrees - 29 Nov 2005 22:16 GMT

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

Reply to this Message

fredg - 29 Nov 2005 22:38 GMT

> 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
[quoted text clipped - 5 lines]
> I'm sure someone on this board is smarter than me...
> ~G

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

Signature

Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

Reply to this Message

Gingertrees - 29 Nov 2005 23:26 GMT

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
[quoted text clipped - 8 lines]
> As criteria in the BookTitle column, use:
> Like "*" & [Enter part of title] & "*"

Reply to this Message

mscertified - 29 Nov 2005 22:42 GMT

Look in Access Help for the LIKE operator

Dorian

Reply to this Message