MS Access question

Sum fuction, could i use nn format? i need to convert it in minutes
Screenshot1.jpg
SELECT [8 qMonthlyCallDurationInboundDetail].Date, Sum([8 qMonthlyCallDurationInboundDetail].Expr1) AS SumOfExpr1, Sum([8 qMonthlyCallDurationInboundDetail].Expr2) AS SumOfExpr2
FROM [8 qMonthlyCallDurationInboundDetail]
GROUP BY [8 qMonthlyCallDurationInboundDetail].Date;

Open in new window

Hiroyuki TamuraField EngineerAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Rey Obrero (Capricorn1)Commented:
try multiplying the result with 24 * 8

SELECT [8 qMonthlyCallDurationInboundDetail].Date
, (Sum([8 qMonthlyCallDurationInboundDetail].Expr1)) * 24 * 60 AS SumOfExpr1
, (Sum([8 qMonthlyCallDurationInboundDetail].Expr2)) * 24 * 60 AS SumOfExpr2
FROM [8 qMonthlyCallDurationInboundDetail]
GROUP BY [8 qMonthlyCallDurationInboundDetail].Date;
Hiroyuki TamuraField EngineerAuthor Commented:
not getting the number
Screenshot1.jpg
Hiroyuki TamuraField EngineerAuthor Commented:
i don't understand nn format.
nn  Minute in two digits (00 to 59).
Your Guide to Achieving IT Business Success

The IT Service Excellence Tool Kit has best practices to keep your clients happy and business booming. Inside, you’ll find everything you need to increase client satisfaction and retention, become more competitive, and increase your overall success.

Rey Obrero (Capricorn1)Commented:
ok, we can't keep on guessing here. we need more information

how did you create the query [8 qMonthlyCallDurationInboundDetail]

or better upload a copy of your db
Rey Obrero (Capricorn1)Commented:
here is link that computes date/time
https://support.microsoft.com/en-us/kb/210604

look for  GetElapsedTime function in the page..
Gustav BrockCIOCommented:
If your Duration field is a time value, you can just sum these value with no conversion at all, then format as you like.
If the sum may exceed 24 hours, use a function like this to obtain a proper format:
Public Function FormatHourMinute( _
  ByVal datTime As Date, _
  Optional ByVal strSeparator As String = ":") _
  As String
  
' Returns count of days, hours and minutes of datTime
' converted to hours and minutes as a formatted string
' with an optional choice of time separator.
'
' Example:
'   datTime: #10:03# + #20:01#
'   returns: 30:04
'
' 2005-02-05. Cactus Data ApS, CPH.

  Dim strHour       As String
  Dim strMinute     As String
  Dim strHourMinute As String
  
  strHour = CStr(Fix(datTime) * 24 + Hour(datTime))
  ' Add leading zero to minute count when needed.
  strMinute = Right("0" & CStr(Minute(datTime)), 2)
  strHourMinute = strHour & strSeparator & strMinute
  
  FormatHourMinute = strHourMinute
  
End Function

Open in new window

/gustav
Hiroyuki TamuraField EngineerAuthor Commented:
sorry, here is the sample
Helpdesk1revA.zip
Rey Obrero (Capricorn1)Commented:
here test this, see queries Q1 and Q2
Helpdesk1revA.accdb

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Hiroyuki TamuraField EngineerAuthor Commented:
thank you.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.