alter column statement for boolen

[Guest]

I am trying to create a statement that will create a boolean column, using
the alter table command/alter column. What data type is used for boolean
values? Thank you.

 

[Dirk Goldgar]

I am trying to create a statement that will create a boolean column,
using the alter table command/alter column. What data type is used
for boolean values? Thank you.

In Jet SQL? BOOLEAN, BIT, LOGICAL, YESNO -- any of these should work.

 

[Marshall Barton]

I am trying to create a statement that will create a boolean column, using
the alter table command/alter column. What data type is used for boolean
values?

A97 Help tells me you can use any of these synonyms:
BOOLEAN, BIT, LOGICAL, YESNO
but if one doesn't work, try another.

I generally use YesNo or Boolean.

 

[Guest]

YesNo worked fine. Thank you.