Avatar of Hiroyuki Tamura
Hiroyuki Tamura
Flag for United States of America

asked on 

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

Microsoft Access

Avatar of undefined
Last Comment
Hiroyuki Tamura

8/22/2022 - Mon