Data Type in Table

[PeteB]

Hi,

I am designing a database to store details of my record collection and I
want to include track time in minutes and second. I have generated a table
and designed a form to input the data but want to be able to add a text box
that shows the total time for the record i.e. is the Sum of the tracktimes
in hours minutes and seconds for that particular record.

What data type should I choose in the table design that will allow me to do
this?

Thankyou in advance

Pete B

 

[Tim Ferguson]

What data type should I choose in the table design that will allow me
to do this?

I would go for a Long Integer and store the time in seconds. You can use
the ControlSource for the textbox on the form to display the formatted
variety:

=Format(LengthInSecs\60,"000") & _
":" & _
Format(LengthInSecs Mod 60, "00")


In order to enter the values, you'll either have to use arithmetic to work
out the number of seconds, or create a little custom dialog form to work it
out for you.

Hope that helps

Tim F

 

[PeteB]

Doug,

Thanks for your quick response, I will have a try at what you are
suggesting. However, I am surprised that there is no easy method of storing
elapsed time to allow subsequent easy manipulation of the data. Don't
athletics clubs or colleges ever store athletes race times in Access
databases?

Pete B