Random Lookup in a Report

Discussion in 'Microsoft Access Reports' started by Guest, Oct 18, 2006.

  1. Guest

    Guest 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.
     
    Guest, Oct 18, 2006
    #1
    1. Advertisements

  2. 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
     
    kingston via AccessMonster.com, Oct 18, 2006
    #2
  3. Guest

    Guest Guest

    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.
     
    Guest, Oct 18, 2006
    #3
  4. Guest

    Guest Guest

    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/Forums.aspx/access-reports/200610/1
    >
    >
     
    Guest, Oct 18, 2006
    #4

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Dale Ring

    Random Pictures In Access Report Problem

    Dale Ring, Sep 4, 2003, in forum: Microsoft Access Reports
    Replies:
    1
    Views:
    232
    Peter Nikolov
    Sep 7, 2003
  2. Guest

    Report error when shown in Word - Random Carriage returns

    Guest, Mar 21, 2005, in forum: Microsoft Access Reports
    Replies:
    0
    Views:
    171
    Guest
    Mar 21, 2005
  3. Guest

    Report creates random duplicate records

    Guest, May 4, 2006, in forum: Microsoft Access Reports
    Replies:
    5
    Views:
    149
    Guest
    May 4, 2006
  4. Guest

    Chunks of random white space on report

    Guest, Sep 28, 2006, in forum: Microsoft Access Reports
    Replies:
    0
    Views:
    156
    Guest
    Sep 28, 2006
  5. Guest

    Report - lookup field to report on

    Guest, Nov 21, 2006, in forum: Microsoft Access Reports
    Replies:
    3
    Views:
    196
    Guest
    Nov 21, 2006
Loading...

Share This Page