Query to search for "includes"

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to run a query for all fields that "include" a search term.

What criteria would I need to run?

Thank you!
 
Thanks Jerry. Can I assume not like *search term* will search for do not
include?
 
Select ... From MyTable
WHERE MyField Like '*The Term to Find*'

HTH

Pieter
 
One more question...how do I say, if I am searching in field 1 like *search
term*, = field 2, if field 2 like *search term*, = field 3...

does that make sense?
 
For example, I am searching a mass mailing list for bad addresses. There are
three different mailing types, business, alternate, and home.

I would like to run a search stating, "if business mailing field includes
"bad address", replace it with alternate business address field. If
alternate business address field includes "bad address", replace it with
home. And if home address field includes "bad address", make field blank.
 
I ASSUME the "bad address" means that the field contains that exact phrase.

You do not want a search but an update query. You need to run the update on
the home address field first then work backwards to the business mailing
field. This is neccesary because if you go the other direction you could be
replacing "bad address" with "bad address."
 
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

Date search query 0
Access Dcount (multiple criteria) 3
Q: query asks for parameters multiple times 4
Query based on Check Box 1
Run 2nd query using results from 1st query 0
Filtering Data From a Table 7
Criteria in Querry to include All and Empty Field 9
Query criteria 1

Back
Top