How do i implement the code for the creation of a table in SQL, i'm having trouble with Boolean field?

Question

CREATE TABLE SaleProperty
(PropertyCode VARCHAR (8) NOT NULL,
Area VARCHAR (20) NOT NULL,
Address VARCHAR (20) NOT NULL,
NoOfBedrooms NUMBER NOT NULL,
NoOfBathrooms NUMBER NOT NULL,
NoOfReceptionRooms NUMBER NOT NULL,
Garage BOOLEAN NOT NULL,
PropertyType VARCHAR (20) NOT NULL,
FreeholdLeasehold VARCHAR (20) NOT NULL,
Price CURRENCY NOT NULL,
PropertyStatus VARCHAR (20) NOT NULL,
DateAdvertised DATE NOT NULL,
CONSTRAINT SaleProperty_PropertyCode_pk PRIMARY KEY (PropertyCode));

..........


I want to the 'Garage' field to be a yes/no field, is this possible, and of so how.... Could you also tell me if my currency field is correct or not...??

I'm using MSAccess 2003 btw!

OK, i done that but it still wont run, can you pls send me the exact code for the garage field... thx!

Answer 1

DROP the NOT NULL constraint from the BOOLEAN type garage field. A "FALSE" value in a BOOLEAN field is effectively a NULL value.

Answer 2

I believe in ms access the boolean data type is yes/no, and is not allowed to be null.