Whats wrong with this code??

**tlinton** · 01-13-2012, 01:16 PM

Can someone please tell me what is wrong with this code? I am trying to create a table and then insert things into it so I can follow along with a tutorial on how to use Having and Group By statements in SQL.

CREATE TABLE writer
("poet" varchar(50) default NULL,"anthology" varchar(40) default NULL,"Copies_In_Stock" tinyint(4) default NULL);

It keeps returning a Syntax Error in CREATE TABLE

Thanks In Advance

**alansidman** · 01-13-2012, 02:46 PM

Look here at the syntax for Create Table

http://www.w3schools.com/sql/sql_create_table.asp

I think that you need to remove the quotation marks from around your field names.

**tlinton** · 01-13-2012, 03:23 PM

Thanks, I tried to enter the code in that format, but still no luck. I'm going to study the syntax for what I am doing a little more in depth and post a solution if I find out! Thanks again for the help!

**protonLeah** · 01-13-2012, 03:46 PM

So, what does your latest code look like?

**JieJenn** · 01-13-2012, 03:48 PM

I don't think access has tinyint type. That's for SQL Server if I remembered it correctly.

**tlinton** · 01-13-2012, 07:14 PM

JieJenn you were right, tinyint isnt supported by access and I had to take out the quotations and the word "default".....i was trying to enter a MySQL code into Access. Thanks!