Search specific name in query

[sweetmikie]

Hi, everyone! I have been working on a database which catalogs titles, authors, etc. Now, I am wanting to design a query where you will be prompted with an empty dialog box, in order to type in the author's surname. Out of 2,500 records, this will pull only works by that author. Is there an easy way to build the dialog box and enter the author's name to search? Thanks for any assistance you may be able to provide.

 

[plog]

In design view, under the field that you want to apply the criteria to, put this in the criteria section:

[Enter Surname]

Then revisit this idea when you realize people can't spell and more than one person shares the surname 'Smith'.

 

[sneuberg]

You can put a parameter in the query's criteria. For example put

[Author's Name]

in the criteria for the author field and when the query is run you will be prompted for it.