Search Engine

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

Guest

Please Help

Can anyone let me know how to create an access query which display records
from a table which contain the text specified by the user in one of its
columns.

So far I have created query but the results displayed are the records which
begin with the text specified in the search engine.

Hope you know what I mean

Thanks

Nick
 
If I understand you correctly, this is what you have to do. Replace the
criteria with a "[" and "]". That will allow the query to prompt user to
input something and access will use it as criteria to do search.

For example:

old way: Select * from table where ID = 1;
new way: select * from table where ID = [Enter a ID:];

Hope this helps.
 
Back
Top