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


ADVERTISEMENT

TimeOut Minus TimeIn

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

ODBC Timeout

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

Where To Actually Set Timeout To Get To Linked Source

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







Copyrights 2005-15 www.BigResource.com, All rights reserved