criteria on yes/no

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a report which I obtain the info from a table using a select query.
One of the fields in the table is a yes/no field. I like to write a criteria
which will prompt a user to type in "yes", "no" or blank in that select
query.

For example, if a user types in "yes", it will show all the records from the
table with "checks" in the field, and if blank, it will show all the records
(both yes and no).

I have a similar criteria for student id. Below is the code. I would like
to write something similar to it.

Like nz([Please Enter Student ID],"*")

Thanks.
 
I have a report which I obtain the info from a table using a select query.
One of the fields in the table is a yes/no field. I like to write a criteria
which will prompt a user to type in "yes", "no" or blank in that select
query.

For example, if a user types in "yes", it will show all the records from the
table with "checks" in the field, and if blank, it will show all the records
(both yes and no).

I have a similar criteria for student id. Below is the code. I would like
to write something similar to it.

Like nz([Please Enter Student ID],"*")

Thanks.
Click to expand...

WHERE YourTable.CheckBox = IIf([What]="Yes",-1,0) OR [What] Is Null;
 
fredg,

Thanks. It works.

fredg said:
I have a report which I obtain the info from a table using a select query.
One of the fields in the table is a yes/no field. I like to write a criteria
which will prompt a user to type in "yes", "no" or blank in that select
query.

For example, if a user types in "yes", it will show all the records from the
table with "checks" in the field, and if blank, it will show all the records
(both yes and no).

I have a similar criteria for student id. Below is the code. I would like
to write something similar to it.

Like nz([Please Enter Student ID],"*")

Thanks.
Click to expand...

WHERE YourTable.CheckBox = IIf([What]="Yes",-1,0) OR [What] Is Null;
Click to expand...
 
Back
Top