Greetings.
I have a macro in access wich is supposed (among other things) to create a new table.
However, I'm having trouble with the Data Type definition, because I get the message:
"Runtime Error 3292: Syntax error in field definition."
The code I'm using is:
Please help!
Many thanks in advance
I have a macro in access wich is supposed (among other things) to create a new table.
However, I'm having trouble with the Data Type definition, because I get the message:
"Runtime Error 3292: Syntax error in field definition."
The code I'm using is:
Code:
SQL = "CREATE TABLE Relatorio(EXTRATO), FlightDate Date(dd/mm/yyyy)"
DoCmd.RunSQL SQL
Please help!
Many thanks in advance