Hello all,

Anyone know the syntax to create a yes/no field in a SQL create table statement (Not using the designer, SQL only) in ms access?

ie something like:
CREATE TABLE test (FIELD1 TEXT(35), FIELD2 YES/NO))

The text field is correct, but I don't know the datatype to create the yes/field. FYI, I've tried boolean and bit; boolean doesn't work, and bit creates the field, but as a text box instead of a checkbox. This is in MS Access

Thanks in advance!

Strick