Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Database Design / December 2004

Tip: Looking for answers? Try searching our database.

creating table with datatype smalltime

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Piet  Geelen - 08 Dec 2004 14:30 GMT
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
Ken Snell [MVP] - 08 Dec 2004 15:11 GMT
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.

Signature

       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
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.