Hello everyone,
I'm creating a database in access but using SQL... its for my course at uni. I want to set a boolean value: Yes/No. but i don't know how to do this, table i want -
CREATE TABLE CASE(
CASE_ID NUMERIC NOT NULL PRIMARY KEY,
CASE_NAME CHAR (255),
CASE_DESCRIPTION CHAR (1024),
CASE_TYPE_ID CHAR (8), /*(FK)*/
CASE_STATUS (YES/NO), <---- here i want it to be either 'OPEN' or 'CLOSED' instead of 'YES or 'NO' is this possible? but would also like how to do a yes and no, lol
CLIENT_ID NUMERIC, /*(FK)*/
INV_OFF_ID NUMERIC, /*(FK)*/
FEE_ID NUMERIC, /*(FK)*/
Cheers
Dan