24 hour time in Access

D

DaveN

Is there any way to display the time in MS Access in a 24 hour format that
includes the seconds. So far all I find is "short time" which is hours
minutes only. I need to show the seconds also, but would prefer the 24 hour
format. Any help is appreciated.

Thanks
Dave
 
R

Rainbow01

2 methods

1) set control panel in windows

2) use format function (i prefer use this method may be better, since
different PC has different setting in control panel)
e.g. Format(YourTimeValue, "H:nn:ss")

"DaveN" 來函：
 
Top