Yes, develop a new query based on the table you want to search (Simple query
Wizard for a select query)
In the criteria row under the field that you want to search type [Enter the
Keyword]
Now every time the query is run, the query will prompt the user to enter the
keyword, it will then only return the records with that word in the field.
You will need to do something else if you want to search for a keyword within
the field though. eg (the quick brown fox) you want to find Brown.
Then the criteira would be Like "*" & [enter the keyword] & "*" now it will
find anything containing the word Brown.
Note they are square brakets
hope this helps, by the way its called a parametric query
--
Advice to Posters.
Check your post for replies or request for more information.
Consider providing some feed back to the response you have recieved.
Kindest Regards Mike B
andrew said:
Hi Tom, thanks for your reply. Is there any way I can do this (just
searching a table) for a keyword using a query which I can then base a
report on so if I run the report I get details of any record in the table
which includes the keyword?
Andrew...
