creating table with datatype smalltime

  • Thread starter Thread starter Piet Geelen via AccessMonster.com
  • Start date Start date
P

Piet Geelen via AccessMonster.com

Hallo,

I want to create a table in a ACCESS database with the results of the skating matches. Therefore I need a datatype where I can use the notation: 1:09:65 or 1:09.65 which means one minute and 9 seconds and 65 hundredth of a second. I also want to calculate with these values.
Is this possible? If so, how can I solve this problem?

Thanks.
Piet Geelen
 
You can't store this datatype directly into a table. You'll need to store
the data most likely as seconds (e.g., 1:09.65 will be stored as 69.65
seconds), and I would do this in a numeric field that has a Single field
size.

If you want to enter the data in the 1:09.65 format, you'll need to use a
textbox on a form to let you type that in, and then use programming to parse
it into the correct number of seconds. Same would be true if you want to
display the the data from seconds into your desired format.

--

Ken Snell
<MS ACCESS MVP>



Piet Geelen via AccessMonster.com said:
Hallo,

I want to create a table in a ACCESS database with the results of the
Click to expand...
skating matches. Therefore I need a datatype where I can use the notation:
1:09:65 or 1:09.65 which means one minute and 9 seconds and 65 hundredth of
a second. I also want to calculate with these values.
 
Back
Top