Switch Query for Yes/No

[james28]

Hello All!




I am trying to use Switch in a query on a field that is a yes/no. The problem that I am having is that the query displays #Error when it is run. From what I can tell, that is due to it returning 0, but I can not fix it.

Below are the two versions of what I have been trying to use.

Available: Switch([Availability]="true","Yes",[Availability]="false","")

Available: Switch([Availability]="yes","Yes",[Availability]="no","")

I tried doing is null and is not null, but everything returns as not null.


Any ideas?


Thank you!

[June7]

If the field is Yes/No type, don't put the parameters in quote marks.

Regardless of any display formatting for a Yes/No field, the value is -1 or 0. True and False are Access/VBA constants. Constants do not go in quotes, otherwise you have the literal text true or false, not the value of the constant.

[james28]

June,


Thank you for the help and for the explanation. That did the trick! I did not realize the literal vs constant issue, but it makes perfect sense now.

[June7]

BTW, should be same case for Yes and No.

Ooops, maybe not, just tested.