Create a shorttime column in ms access

[visweswaran2830]

I created runtime Ms-access db at runtime. Now I want to set date/time field as short time. Can U help me...,..

[Plater]

If you created it at run time, create the table with the shorttime type?

[visweswaran2830]

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]

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