Searching for text

  • Thread starter Thread starter scubadiver
  • Start date Start date
S

scubadiver

I would like to search for the word "and" in a query. How is it done?

cheers
 
By using wild cards. To find records where the word "and" exists in a
specific field you would use something like the following.

Field: Expr1: " " & YourFieldName & " "
Criteria: Like "* and *"

Note that I have added a space before and after the field. This is so you
can find matches on just AND and not on hANDle, rANDom, etc and so that if
your text begins with AND or ends with AND, you will pick up those records
also.

--
John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County
..
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Multiple Parameters to search a field 1
Search for a word in a memo field ? 3
Search for words in a record 2
Parameters to search between years 2
Access 2000 append unbound text box values to a table 0
How Search RAFT2 control by querying 0
Count text values in a Access Field 0
Query searching multiple fields 1

Back
Top