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

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

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:
    250
    Peter Nikolov
    Sep 7, 2003
  2. Guest
    Replies:
    5
    Views:
    866
    Guest
    Apr 4, 2005
  3. Guest

    Report with Sub-Report with NO-DATA on Sub-Report

    Guest, Feb 7, 2006, in forum: Microsoft Access Reports
    Replies:
    11
    Views:
    809
    Marshall Barton
    Feb 16, 2006
  4. Guest
    Replies:
    0
    Views:
    596
    Guest
    Feb 8, 2006
  5. Guest

    Report - lookup field to report on

    Guest, Nov 21, 2006, in forum: Microsoft Access Reports
    Replies:
    3
    Views:
    276
    Guest
    Nov 21, 2006
  6. Gdareos

    Easy report? How to report on a record, skip, report, etc.

    Gdareos, Oct 13, 2007, in forum: Microsoft Access Reports
    Replies:
    1
    Views:
    456
    Guest
    Oct 13, 2007
  7. mogll
    Replies:
    4
    Views:
    514
    mogll
    Jan 26, 2009
  8. iynque
    Replies:
    1
    Views:
    4,892
    Duane Hookom
    Jun 5, 2009
Loading...