[MS_AccessPros] Create Table Syntax

 

I am using the following code  to create a new table in my database:

 

CurrentDb.Execute "CREATE TABLE testss3(ID COUNTER PRIMARY KEY, " & _
                    "[stu id] LONG, " & _
                    "description TEXT(50), " & _
                    "document TEXT(255), " & _
                    "timexx DATETIME, " & _
                    "documentdate DATETIME ," & _
                    "entrydate DATETIME)", dbFailOnError

 

It works fine, however I would like to format  the field 'timexx' as short time and 'documentdate' as short date. Is there anyway to-do this in the above command or in an ALTER TABLE command?.

As always all help is greatly appreciated.

__._,_.___

Reply via web post

Reply to sender

Reply to group

Start a New Topic

Messages in this topic (1)

Recent Activity:

Visit Your Group

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use • Send us Feedback

.

__,_._,___