ACC: Query with Parameters to Evaluate Complex Criteria (103252)
The information in this article applies to:
- Microsoft Access 1.0
- Microsoft Access 1.1
- Microsoft Access 2.0
- Microsoft Access for Windows 95 7.0
- Microsoft Access 97
This article was previously published under Q103252
Moderate: Requires basic macro, coding, and interoperability skills.
SUMMARY
In Microsoft Access, you can use variable parameters in queries. This
article discusses how to construct a query that requires more than one
prompt. Each parameter can be used both as criteria and as a field to allow
complicated evaluation of the value entered in each parameter.
REFERENCES
For more information about these kinds of queries, search the Help Index
for "Query by Form," or "Parameter Queries," or ask the Microsoft Access 97
Office Assistant.
Modification Type: | Major | Last Reviewed: | 5/6/2003 |
---|
Keywords: | kbinfo KB103252 |
---|
|