Int([TimeOut]-[TimeIn]) & " Day "
Dec 20, 2007
Hello, (not sure if this post belongs in the Reports forum, sorry)
From 2 Tables: In the Query I have these fields:
LogID | UserID | TimeIn | TimeOut |
with an additional column where I have this:
TotalTime: Int([TimeOut]-[TimeIn]) & " day " & Format([Timeout]-[TimeIn],"h"" hr ""n"" min ""s"" sec""")
The above gives me the total time "TimeIn" to "TimeOut". For example:
Record1: 1 day 2 hours 33 minutes 44 seconds.
Record2: 2 days 3 hours 4 minutes 6 second.
No Problems there.
In a Report based on this query, I can show each record and GROUP IT BY >USERID<
I need help with the following :
In the Group Footer for UserID, I need to SUM the column (TotalTime) from the above Query. So that the SUM of the above 2 records shows:
Total All Records: 3 days 5 hours 37 minutes 50 seconds.
Any advice please.
Thank You.
View Replies
Dec 13, 2006
I have a datasheet subform that is acting like a timesheet. I have a TimeIn field and TimeOut field (both fields formatted as Medium Time); and a field for Hours to total the time. I used the expression =HoursAndMinutes([TimeOut]-[TimeIn]) that I found in another post, and it didn't work. All I got was #Name. Any thoughts as to why that's happening? I would preferably like the hours to total in tenths of hours, ie. 10.5.
Thanks
ScrmingWhisprs
View 6 Replies
View Related
Dec 28, 2005
Am getting an ODBC Timeout message when trying to run a SQL stored procedure from Access. I know that I can set the Timeout property in an Access query, but can I do the same thing using the code below?
Code: Set oconn = New ADODB.Connection oconn.Open "Driver={SQL Server};" & _ "Server=SQLSW;" & _ "Database=PHRpt;" & _ "Uid=user;" & _ "Pwd=none;" SQL = "dbo.spACH_RunAllProcs '" & StartDate & "', '" & EndDate & "'" Set rs = oconn.Execute(SQL)
View 1 Replies
View Related
Oct 21, 2014
I have a linked excel table in my database but sometimes because the network is down I am getting "not responding" message from Access if I accidentlaly try to open the linked table while off-line. That does not seem to timeout at all. I am wondering where I can actually set the timeout so Access will not hang trying to get to the linked source?
View 1 Replies
View Related