Re: Can I query using 2 *
- From: fredg <fgutkind@xxxxxxxxxxxxxxx>
- Date: Thu, 8 Jun 2006 16:14:48 -0700
On Thu, 8 Jun 2006 15:35:02 -0700, Tall Mary wrote:
I have a Book Database with one field named Titles.
Is it possible to make a query using 2 partial names in the field name to
get all the matching items I want in one query?
For example, *Gone* (Gone Fishing, Gone with the Wind, Gone Crazy, etc) and
*Parenting*(for Modern Day Parenting, Good Parenting Skills, Parenting a
Teenager, etc), so I get all 6 Book Titles ?
I tried Like "*" Or [Enter Partial Title of Book] & "*" but it returns
the entire database's Book Titles. Help.
To find the phrase anywhere in the field:
Like "*" & [Enter Partial Title of Book] & "*"
To find the phrase only at the beginning of the field:
Like [Enter Partial Title of Book] & "*"
To find the phrase only at the end of the field:
Like "*" & [Enter Partial Title of Book]
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail
.
- Prev by Date: Re: format problem
- Next by Date: Re: Calculations
- Previous by thread: Re: Trouble combining records -- code to combine text from different records into one string
- Next by thread: Re: Can I query using 2 *
- Index(es):
Relevant Pages
|
