Article ID: 198626 - View products that this article applies to.
This article was previously published under Q198626
This article has been archived. It is offered "as is" and will no longer be updated.
This article applies only to a Microsoft Access database (.mdb).
Novice: Requires knowledge of the user interface on single-user computers.
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.
To create a parameter query that displays all records that contain Yes, No, or all values, follow these steps:
For more information about Yes/No fields, please see the following articles in the Microsoft Knowledge Base:
(https://support.microsoft.com/kb/209505/EN-US/ )ACC2000: Expressions to Count Yes, No, and Other Responses
(https://support.microsoft.com/kb/209700/EN-US/ )ACC2000: Cannot Use "y," "n," "t," or "f" in Yes/No Field
(https://support.microsoft.com/kb/209823/EN-US/ )ACC2000: How to Use the LIKE Operator in Parameter Queries