var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
How do i sum (add) multple [hh:mm:ss] fields in a query together and if its more than 24hr then it will still show hours ie 25:10:12 this is = 25hr 10min and 12sec
Force an explicit conversion of the Date/Time values to Singles (using CSng()) before performing the additions, then use a user-defined format (or a function) to display the result in the proper format.
Have a nice day!
View Tag Cloud
Log in with your username and password
Forgot your password?
Subscribe to dBforums Brief to receive special offers from dBforums partners and sponsors