ACC2000: Parameter Query on Yes/No Field That Accepts Yes, No, and *
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/Nodata 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:
- Open the sample database Northwind.mdb.
- In the Database window, click Queries under Objects, and then click New.
- In the New Query dialog box, click Design View and click OK.
- In the Show Table dialog box, select the Products table, click Add, and then click Close.
- In the first column in the QBE grid, type the following:
Field: MyParam: IIf([Discontinued]=-1, "Yes","No")
Criteria: Like [Enter Yes, No or *]
- On the Query menu, click Run.
- Note that you are prompted with the Enter Parameter Value box. You can enter Yes, No, or *, where * returns all values.
For more information about Yes/No fields, please see the followingarticles in the Microsoft Knowledge Base:
ACC2000: Expressions to Count Yes, No, and Other Responses209700
ACC2000: Cannot Use "y," "n," "t," or "f" in Yes/No Field209823
ACC2000: How to Use the LIKE Operator in Parameter Queries
Article ID: 198626 - Last Review: 10/11/2013 20:28:10 - Revision: 2.0
Microsoft Access 2000 Standard Edition
- kbnosurvey kbarchive kbhowto KB198626