Simple SQL Statement

[threni]

Trying to write an SQL string for creating a table with two fields.
One field goes fine:

SQL = "CREATE TABLE x" & _
" (f CHAR(5))"

DoCmd.RunSQL SQL

But
SQL = "CREATE TABLE x" & _
" (f CHAR(5)), (g CHAR(5))"

doesnt. Please tell me what I am missing.

I am not including the emoticons in the code, btw.

 

[DJkarl]

Try this:

SQL = "CREATE TABLE x" & _
" (f CHAR(5), g CHAR(5))"

 

[threni]

Thanks, but I still get an "error in field statement" message for that. Here is the actual code:

SQL = "CREATE TABLE [" & strStudent & "]" & _
"(Piece CHAR(20), Date CHAR(10))"
DoCmd.RunSQL SQL

It works with one field specified, thus:

SQL = "CREATE TABLE [" & strStudent & "]" & _
" (Piece CHAR(20))"

Would appreciate any ideas- this sort of clerical fussing about prevents one from actually doing any interesting programming.

 

[DJkarl]

Date is generally a reserved word, call your Date field something else.

 

[threni]

Thanks again, that was the problem. Pretty dumb of me, and clever of you.