Parameter Query and WildCards

[Angela Semotan]

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,
Angela