Hi All
Can anyone tell me how to go about making a half hour interval report. I have made an hourly version but cheated to do it can someone show me how to modify the attached to make a half hour report. Time format is hh:mm:ss let me know if you require any further info
SELECT dbo_RouteCallDetailAccess.Date, Left([dbo_RouteCallDetailAccess].[Time],2) & ":00" AS [Hour], ROUTING01_V_ROUTING.DNIS1, ROUTING01_V_ROUTING.PRODUCT, Count(ROUTING01_V_ROUTING.PRODUCT) AS Calls, dbo_RouteCallDetailAccess.Label
FROM dbo_RouteCallDetailAccess INNER JOIN ROUTING01_V_ROUTING ON dbo_RouteCallDetailAccess.DialedNumberString = ROUTING01_V_ROUTING.DNIS1
GROUP BY dbo_RouteCallDetailAccess.Date, Left([dbo_RouteCallDetailAccess].[Time],2) & ":00", ROUTING01_V_ROUTING.DNIS1, ROUTING01_V_ROUTING.PRODUCT, dbo_RouteCallDetailAccess.Label, ROUTING01_V_ROUTING.BUSINESS_GROUP, ROUTING01_V_ROUTING.CALL_CLASSIFICATION
HAVING (((dbo_RouteCallDetailAccess.Date) Like [Input]) AND ((ROUTING01_V_ROUTING.BUSINESS_GROUP)="SKYDEALS") AND ((ROUTING01_V_ROUTING.CALL_CLASSIFICATION)="BL"))
WITH OWNERACCESS OPTION;
Can anyone tell me how to go about making a half hour interval report. I have made an hourly version but cheated to do it can someone show me how to modify the attached to make a half hour report. Time format is hh:mm:ss let me know if you require any further info
SELECT dbo_RouteCallDetailAccess.Date, Left([dbo_RouteCallDetailAccess].[Time],2) & ":00" AS [Hour], ROUTING01_V_ROUTING.DNIS1, ROUTING01_V_ROUTING.PRODUCT, Count(ROUTING01_V_ROUTING.PRODUCT) AS Calls, dbo_RouteCallDetailAccess.Label
FROM dbo_RouteCallDetailAccess INNER JOIN ROUTING01_V_ROUTING ON dbo_RouteCallDetailAccess.DialedNumberString = ROUTING01_V_ROUTING.DNIS1
GROUP BY dbo_RouteCallDetailAccess.Date, Left([dbo_RouteCallDetailAccess].[Time],2) & ":00", ROUTING01_V_ROUTING.DNIS1, ROUTING01_V_ROUTING.PRODUCT, dbo_RouteCallDetailAccess.Label, ROUTING01_V_ROUTING.BUSINESS_GROUP, ROUTING01_V_ROUTING.CALL_CLASSIFICATION
HAVING (((dbo_RouteCallDetailAccess.Date) Like [Input]) AND ((ROUTING01_V_ROUTING.BUSINESS_GROUP)="SKYDEALS") AND ((ROUTING01_V_ROUTING.CALL_CLASSIFICATION)="BL"))
WITH OWNERACCESS OPTION;