Community
Showing results for 
Search instead for 
Do you mean 
Reply

search YES / NO fields

New Member
Posts: 8
Country: United_Kingdom

search YES / NO fields

I am trying to search for all our contacts who have the postal Yes/No box checked yes. I cannot add this as a column or choose it as a field when doing an advanced query.

Any idea why I cant search for this?

 

Thanks!

Administrator
Posts: 4,024
Country: United_Kingdom

Re: search YES / NO fields

Hi Gemma,

 

It should be possible to lookup on a yes/no field. Perhaps the field itself named differently to the label next to it, and is causing confusion when selecting it in lookups.

 

From the screenshot below you can see I have selected the field in a lookup:

Act!_2017-09-07_16-49-49.png

 

If you're having trouble finding the field name, just right click the field and choose to lookup on it:

Act!_2017-09-07_16-53-33.png

Bronze Elite Contributor
Posts: 1,409
Country: United_Kingdom

Re: search YES / NO fields

[ Edited ]

I have tested on the same version and if I understand your issue correctly I am not able to replicate it as it gave the option of Values True or False from a drop down and then gave the expected results.

 

Please could you detail just where it is not functioning for you?

 

If you are unable to find the fields have you determined the correct name of the field as per Gary's reply as the designer of the database may have used different names on the label to the field name. As Gary states Right Clicking in the Yes/|No box should then give the lookup option with the actual field name in it..