09-07-2017 07:43 AM
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?
09-07-2017 08:55 AM
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:
If you're having trouble finding the field name, just right click the field and choose to lookup on it:
09-08-2017 02:25 AM - edited 09-08-2017 02:56 AM
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..