Re: Random Lookup in a Report

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

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/Forums.aspx/access-reports/200610/1

.

Relevant Pages

  • Re: Ramsey note $118,000
    ... That phrase was a term of endearment used by Patsy to John, ... the Ramseys normal social circle, ... The ransom note is interesting, but would it really trump DNA at trial? ... a report that the Ramseys had recently rented the movie which includes ...
    (alt.true-crime)
  • Re: Find a word or phrase in a report in Access
    ... > report and take the user to that word or phrase? ... With the report in view, you could publish to Word and do a search there: ... (Free after monsieur Leclerc in 'Allo, ... Prev by Date: ...
    (comp.databases.ms-access)
  • Re: 20 Years of Les Miz - Where were you?
    ... There's a report of a woman who's seen the show 738 times. ... she knows 90% of the words and can almost always spot a mistake. ... the phrase "longest-running musical". ...
    (rec.arts.theatre.musicals)
  • Re: Frustration continues
    ... Ronnie the Tim wrote: ... > report. ... Did you notice the phrase 'by his standards'? ...
    (uk.sport.football.clubs.rangers)
  • Re: "Reply" or "Respond Back"
    ... Smartin wrote: ... The phrase is unusual, but might be that used by ... Supervisor: "Respond back and tell him the report will be completed by ...
    (alt.usage.english)