Format datatype while creating table

[BuzzerTom]

Hi all,

Below is my SQL statement that creates a table. It works fine, but my column called Room1 is formated as text box (wich is the standerd in Microsoft Access) but I want it as check box. How can I change this SQL statement so that when I open the table in access I see the values from the Room1 column as check boxes and no longer as text boxes?

CREATE TABLE tbl_test(Autonummer AUTOINCREMENT CONSTRAINT Autonummer PRIMARY KEY, Datum DATE, Room1 LOGICAL)

Thanks in advance,
Buzzer

 

[jbenson001]

are you creating an Access or SQL Server table.

 

[mrdenny]

As AUTOINCREMENT isn't a valid SQL Server command and LOGICAL isn't a valid SQL data type he's doing this in Access. You'll want to ask someone in one of the Access forums. Most of the folks in the SQL forums don't work with Access.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[BuzzerTom]

Thanks for the response anyway, I'll try it there then...

 

[mrdenny]

No problem.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com