Connecting Tech Pros Worldwide Help | Site Map

Create a shorttime column in ms access

Newbie
 
Join Date: Nov 2009
Posts: 9
#1: 3 Weeks Ago
I created runtime Ms-access db at runtime. Now I want to set date/time field as short time. Can U help me...,..
Plater's Avatar
Moderator
 
Join Date: Apr 2007
Location: New England
Posts: 7,158
#2: 3 Weeks Ago

re: Create a shorttime column in ms access


If you created it at run time, create the table with the shorttime type?
Newbie
 
Join Date: Nov 2009
Posts: 9
#3: 2 Weeks Ago

re: Create a shorttime column in ms access


I created runtime Ms-access db at runtime.In that, a field has datatype as datetime. It automatically created in that datetime type. but I want to change it format as short time can u
Plater's Avatar
Moderator
 
Join Date: Apr 2007
Location: New England
Posts: 7,158
#4: 2 Weeks Ago

re: Create a shorttime column in ms access


Right, YOU created the database. Then YOU can decide how the table is created? This is really a question for the Access people if you need help with your Create Table syntax
Reply