[DanDeCoder]

I'm trying to add a table to my database using SQL however I'm getting 'syntax error' on MS Access 2010.
This is the SQL code I have used thus far:

CREATE TABLE Child_Diary
(
Child_ID TEXT(4) CONSTRAINT child_id_no_pk PRIMARY KEY,
Room_ID TEXT(25),
Date TEXT(25),
Time TEXT(25));

However the syntax error is highlighting the 'Date' line. Not sure where I'm going wrong to be honest, I've managed to build all other tables but this one is failing.

I've tried changing the TEXT to INTEGER (just to see if this works) but to no avail.
Can someone shed some light on my error/where I've gone wrong?

Thanks,

[DanDeCoder]

I think I've sussed it. I've now wrapped the Date and Time in square brackets so it looks like the following:

CREATE TABLE Child_Diary
(
Child_ID TEXT(4) CONSTRAINT child_id_no_pk PRIMARY KEY,
Room_ID TEXT(25),
Date TEXT(25),
Time TEXT(25)); 

So far so good...