I am new to this and having a problem. I have a time field [start] and a [end] field."=DateDiff("n",[start],[end])" That is stored in a field call "minutes". I devide by 60 "hours"and am trying to store the value in a table for later use. Total=hours. For some reason I can't store the value. It seems to have something to do with storing a time value. Help
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
calculate time and save in table
- Thread starter priac
- Start date
If you have the two values required to calculate the result, you shouldn't store the result unless you have a reason that you didn't provide.
Duane
Hook'D on Access
MS Access MVP
Duane
Hook'D on Access
MS Access MVP
If you want to store a time duration, you shouldn't use a date/time field. Consider using a numeric double or integer or similar.
Duane
Hook'D on Access
MS Access MVP
Duane
Hook'D on Access
MS Access MVP
- Status
Similar threads
- Locked
- Question
