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.

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

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


TAWise wrote:
>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.

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ports/200610/1

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

"TAWise" wrote:

> 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.

Thank you Kingston. Worked wonderfully.

"kingston via AccessMonster.com" wrote:

> Base the report on a parameter query that searches the data for the random
> word or phrase:
>
> [Field] Like "*" & [Search criteria] & "*"
>
>
> TAWise wrote:
> >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.
>
> --
> Message posted via AccessMonster.com
> http://www.accessmonster.com/Uwe/For...ports/200610/1
>
>