Can't create YES/NO field using CREATE TABLE in Access

[filiberto]

the following works:

DoCmd.RunSQL "CREATE TABLE myTable (myText TEXT);

but this doesn't:

DoCmd.RunSQL "CREATE TABLE myTable (myBool YES/NO);

Is there a way to do the above?

Thanks

 

[Nancy2]

Syntax is YESNO versus YES/NO