Make Table with a Yes/No Field

[NMiller007]

I am using a Make Table Query, but I cannot get one of the fields to be a Yes/No Field. I have tried setting the values to -1s & 0s and TRUEs & FALSEs and YESes & Nos, but the values come out as -1,0 with a field type of number.

Is it possible to force the field type to be Yes/No in the make table query? What is the best way to accomplish this?

Thanks.

 

[Darrylles]

NMiller,

A "Yes/No" field is a boolean data-type.

This is stored as -1 (True), 0 (False).

YOU interpret those values as YOU wish.

E.g. -1 can = YES, TRUE, ON etc, but is generally viewed as the POSITIVE 'meaning', whereas 0 can = NO, FALSE, OFF (i.e. the negative 'meaning').

You can 'display' these values in a 'dummy' field as YES, NO, TRUE, FALSE by using code.

ATB

Darrylle


Never argue with an idiot, he'll bring you down to his level - then beat you with experience.