Re: creating table with datatype smalltime
From: Ken Snell [MVP] (kthsneisllis9_at_ncoomcastt.renaetl)
Date: 12/08/04
- Next message: nvishnu: "Custom Fields"
- Previous message: Piet Geelen via AccessMonster.com: "creating table with datatype smalltime"
- In reply to: Piet Geelen via AccessMonster.com: "creating table with datatype smalltime"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 8 Dec 2004 10:11:49 -0500
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" <forum@AccessMonster.com> wrote in
message news:87a7f63ba7e646d6bfff14727950f257@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
>
> --
> Message posted via http://www.accessmonster.com
- Next message: nvishnu: "Custom Fields"
- Previous message: Piet Geelen via AccessMonster.com: "creating table with datatype smalltime"
- In reply to: Piet Geelen via AccessMonster.com: "creating table with datatype smalltime"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
