Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Parameter Query and WildCards

Discussion in 'Information Technology' started by Angela Semotan, Nov 1, 2005.

  1. Angela Semotan

    Angela Semotan
    Expand Collapse

    I have created a (below) Parameter Query. I would like to change this query
    so that I get results as follows:

    1. I want my Query not to be limited to Authors names - but include text in
    all fields. This would basically be a free-text search. In the past I have
    created such a parameter using a combination of wildcards. Unfortunately,
    that was years ago and has since become a fuzzy memory.

    2. I want the results to be multiple. I have a multi-page report to apply to
    this query. Right now, I only get one result and there are several records
    with identical information in the author field.

    SELECT Index_Author.Author AS Srch_Author_Author, Catalog.accession_no,
    Catalog.abstract, Catalog.subjects, Catalog.[journal title], Catalog.author
    AS Catalog_author, Catalog.title, Catalog.volume_issue, Catalog.publisher,
    Catalog.publisher_location, Catalog.pages, Catalog.date, Catalog.isbn,
    Catalog.issn, Catalog.oclc, Catalog.owned, Catalog.holdings,
    Catalog.language, Catalog.notes, Catalog.acquisition_method
    FROM [Catalog] INNER JOIN Index_Author ON Catalog.author = Index_Author.Author
    WHERE (((Index_Author.Author)=[Enter Author Name:]));

    Please advise - Thank you,
  2. Loading...

Share This Page