1 2 3 4 5
| SELECT DISTINCTROW Tbl_Main_Table.Client_Name, CDate(Int([Date_Time_Send])) AS Expr1, Tbl_Main_Table.Query_Definition_Level1, format(Sum(Tbl_Main_Table.Time_Spent_On_Query_Free_text), "hh:mm:ss") AS SumOfTime_Spent_On_Query_Free_text
FROM Tbl_Main_Table
GROUP BY Tbl_Main_Table.Client_Name, CDate(Int([Date_Time_Send])), Tbl_Main_Table.Query_Definition_Level1, Tbl_Main_Table.User_Name
HAVING (((CDate(Int([Date_Time_Send]))) Between [From:] And [To:]) AND ((Tbl_Main_Table.User_Name)="monnom"))
ORDER BY CDate(Int([Date_Time_Send])); |
Partager