ACC97: How to Create a Parameter Query in Microsoft Access (304447)
The information in this article applies to:
This article was previously published under Q304447 Novice: Requires knowledge of the user interface on single-user computers.
This article applies only to a Microsoft Access database (.mdb).
SUMMARY
You can use criteria in a query in Microsoft Access to restrict the set of records that the query returns. To query for different records each time that you run a particular query, you may want the query to prompt you for criteria to enter, for example, "a date from" to "a date to." A query that prompts you for criteria is called a parameter query. This article shows you how to create parameter queries in Microsoft Access.
REFERENCESFor more information about creating queries, click Microsoft Access Help on the
Help menu, type create a query in the Office Assistant or
the Answer Wizard, and then click Search to view the topics
returned. For additional information about using forms or custom dialog boxes for parameter queries, click the article number below
to view the article in the Microsoft Knowledge Base:
95931 ACC: How to Use the Query-by-Form (QBF) Technique
For additional information about creating select queries, click the article number below
to view the article in the Microsoft Knowledge Base:
304444 ACC97: How to Create a Select Query in Microsoft Access
For additional information about creating crosstab queries, click the article number below
to view the article in the Microsoft Knowledge Base:
304446 ACC97: How to Create a Crosstab Query in Microsoft Access
For additional information about how to convert a select query to an action query, click the article number below
to view the article in the Microsoft Knowledge Base:
304448 ACC97: How to Convert a Select Query to an Action Query
For additional information about modifying query properties, click the article number below
to view the article in the Microsoft Knowledge Base:
304451 ACC97: How to Modify Query Properties in Microsoft Access
You can also view queries for most of the techniques described in these articles in the sample file QrySmp97.exe from the following article: 182568 ACC97: Microsoft Access 97 Sample Queries Available in Download Center
Modification Type: | Major | Last Reviewed: | 9/25/2003 |
---|
Keywords: | kbhowto KB304447 |
---|
|