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.
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.