text searching with select query

  • Thread starter Thread starter Brian Henry
  • Start date Start date
B

Brian Henry

Is it possible to do a query in access that will find all the rows which
contain the text a user specifies? like if my table is like this

SearchTable
===========
id pk autonumber
textField memo

could i do a select statement to find all the rows that contain the text
"help me" in the textField column at any position in it? I know you can do
this in SQL server for searching..... Thanks
 
Yes, you can do a select query that looks for specific
text. If the query is run from a form you can have the
query pick up the paramaters from a fill in box on the
form.
 
how would i do that though? ive never goten it to work in access.. in SQL
server you can just do a like %text% clause... how would you implement this
in access? thanks
 
Back
Top