Query

  • Thread starter Thread starter Query on description
  • Start date Start date
Q

Query on description

I am trying to run a query that will search a field looking for a perticular
word and return all of the selections where that word shows up.
 
In the query criteria, use the Like command. Like "Chicago" or Like "7th grade"
 
Close, but you forgot the wild cards

Like "*Chicago*"

That will return all records where the field has "chicago" somewhere in the
field. For instance, if the field contained "I lived in Chicago in 1989" then
the record would be returned.

John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
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

query not giving results but with no error? 1
Query questions 1
Using field contents as criteria in update query 1
Union Querry 1
Combine Duplicates in Query 0
Creating OR, AND query in access and getting parametrs frm access 2
Running sum 3
Make table query: [Enter 1] AS Test 1

Back
Top