Time Format in Acces2k (2000)

Topic

New Reply

can anyone tell me the correct way to display a field in min – sec – hun format in access 2k? It does not matter what the separator is

Reply | Quote

Replies

Format([DateTimeField],”mm:ss”)
Your field has to be of Date/Time type.

Reply | Quote

the min and sec are fine but the hun does not show – that’s my problem

Reply | Quote

Hmmmm ……

I’ve been trying to think ….. what is “hun”?

If you are referring to hundredths of a second, then you have a problem. Access does not return this. The smallest increment for a Date/Time value is “seconds”.

You may be able to do this with code using the Timer built into a form.

HTH
RDH

Reply | Quote

Take a look at this post and see if it helps. Be warned that this code displays the “hundreds” as a two-digit value, so you may have to play with it.

Reply | Quote

You could use a single type field and store the time as a number of seconds but you’ll have to do all the calculating and formatting yourself.

See this post for more information.

Reply | Quote