UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> Time Length, Access 2010    
 
   
asimze
post Dec 4 2019, 05:06 PM
Post#1



Posts: 173
Joined: 12-December 12
From: Bosna i Hercegovina


In table have fields where have to input length of time. Later in program this value will use for calculation: in some period of date, sum hours for some tip of work. Result will be 164:00 or 56:00. Which Data Type and Format? DateTime or Integer??? App is for record working time.
Go to the top of the page
 
theDBguy
post Dec 4 2019, 05:21 PM
Post#2


UA Moderator
Posts: 76,866
Joined: 19-June 07
From: SunnySandyEggo


I would probably use a Long Integer and just format the result after all calculations are done.

--------------------
Just my 2 cents... "And if I claim to be a wise man, it surely means that I don't know" - Kansas
Access Website | Access Blog | Email
Go to the top of the page
 
cheekybuddha
post Dec 4 2019, 05:23 PM
Post#3


UtterAccess Moderator
Posts: 11,907
Joined: 6-December 03
From: Telegraph Hill


Hi,

Use Integer (or Decimal) to record units of time (hours or minutes).

Remember to make sure user distinguish between hours and minutes,

eg is 1.25 hrs = 1 hour 25 minutes OR 1 hour 15 minutes ???

If you do not establish this, then your calculations may be wrong.

hth,

d

--------------------


Regards,

David Marten
Go to the top of the page
 
asimze
post Dec 4 2019, 05:25 PM
Post#4



Posts: 173
Joined: 12-December 12
From: Bosna i Hercegovina


Thx for advice!
Best regards.
Asim
Go to the top of the page
 


Custom Search


RSSSearch   Top   Lo-Fi    11th December 2019 - 08:48 AM