Still having trouble searching for a particular word

[meeble]

Hello,

I made a query which simply returns everything in the table. I then made a report from this query and made it look pretty.

What I would like is, when I press the button on the form that opens the report, before the report opens, I get a little pop up box that asks me to enter a word. When I enter this word, the query is modified to return only the records that have this word (in any field, case not important).

How do I do this please?

Many thanks

James

 

[Rick39]

Try something like:

SELECT YourTableName.Field1, YourTableName.[Field2], YourTableName.Field3, [Field1] & [Field2] & [Field3] AS SearchCriteria
FROM YourTableName
WHERE ((([Field1] & [Field2] & [Field3]) Like "*" & [Enter Word to Search For] & "*&quot);


Hope this helps

Rick