Triple state Yes/No field

[pmcguire]

I want to distinguish between Yes, No, and null (or True, False, and null). How should I design my table? Can I make the field's type Yes/No? Or must I type it something else? If so, what is the correct data type

Thanks.

 

[Steve Schapel]

Pmcguire,

No, the value of a field of Yes/No data type must always be Yes or No
and there is no provision for Null. Depends on how you want to use this
field, but maybe an integer data type would be applicable, in which case
you could use the same default convention as Access, i.e. 0 for No and
-1 for Yes, and also allow the Null option.