Random Lookup in a Report

[Guest]

My database contains approximately 700 questions divided into several
category-type tables and reports. There are 80 respondents to the 700
questions and these, too, are incorporated into the reports. The management
team that will be using this database would like to be able to search for a
"random" word or phrase in the database and have the matching
questions/responses compiled into a report. How can I set up a report that
will populate based on whatever word or phrase that they may choose? Thanx.

 

[kingston via AccessMonster.com]

Base the report on a parameter query that searches the data for the random
word or phrase:

[Field] Like "*" & [Search criteria] & "*"

 

[Guest]

I have resolved this issue with a wildcard parameter query. Thank you

 

[Guest]

Thank you Kingston. Worked wonderfully.

Base the report on a parameter query that searches the data for the random
word or phrase:

[Field] Like "*" & [Search criteria] & "*"

My database contains approximately 700 questions divided into several
category-type tables and reports. There are 80 respondents to the 700
questions and these, too, are incorporated into the reports. The management
team that will be using this database would like to be able to search for a
"random" word or phrase in the database and have the matching
questions/responses compiled into a report. How can I set up a report that
will populate based on whatever word or phrase that they may choose? Thanx.