AnsweredAssumed Answered

Checkbox Fields and Perform Find

Question asked by EmerO'Toole on Apr 16, 2012
Latest reply on Apr 16, 2012 by Dillik


Checkbox Fields and Perform Find



My database of contacts has several checkbox fields - including, for example, fields for region and discipline. Some of these checkbox fields have been added as the database has developed, so, in many of the earlier data entries, the checkbox fields are now blank.

I would like to be able to search my database for blank checkbox fields - that is, checkbox fields in which no data has been entered. I'd like to be able to find, for example, contacts for whom no region or no discipline is listed.

I have tried a search which omits all the options in a checkbox field, but, unfortunately, this returns every single record because the programme appears to search for 'any' not 'all' of the desired omissions.

I'd be very grateful for any advice on this,