Yes/No variants

Hi

I have some data sets where the responsible managers are adamant that they need to differentiate between the following types of boolean data elements (version 2.24, Tracker):

  • Yes Only (no problem)

  • Yes or No (no problem)

  • Yes or No or Not Applicable (any way to deal with this other than a text option set?)

  • Yes or No or Unknown (any way to deal with this other than a text option set?)

The idea of using a null value to automatically represent either N/A or Unknown is not popular…

Regards

calle

···

Calle Hedberg

46D Alma Road, 7700 Rosebank, SOUTH AFRICA

Tel/fax (home): +27-21-685-6472

Cell: +27-82-853-5352

Iridium SatPhone: +8816-315-19119

Email: calle.hedberg@gmail.com

Skype: calle_hedberg