ACC2000: Parameter Query on Yes/No Field That Accepts Yes, No, and * (198626)
The information in this article applies to:
This article was previously published under Q198626 This article applies only to a Microsoft Access database (.mdb).
Novice: Requires knowledge of the user interface on single-user computers.
SUMMARY
This article describes how to create a parameter query that uses a Yes/No
data type field that accepts the values of Yes, No, and * (asterisk), where
* returns all values in the field.
REFERENCES
For more information about Yes/No fields, please see the following
articles in the Microsoft Knowledge Base:
209505 ACC2000: Expressions to Count Yes, No, and Other Responses
209700 ACC2000: Cannot Use "y," "n," "t," or "f" in Yes/No Field
209823 ACC2000: How to Use the LIKE Operator in Parameter Queries
Modification Type: | Major | Last Reviewed: | 6/24/2004 |
---|
Keywords: | kbhowto KB198626 |
---|
|