I was thinking of incorporating this Order by into my select statement
Code:
ORDER BY
IIF([Message Tracking].[Hour] = '6AM',0,1),
IIF([Message Tracking].[Hour] = '7AM',0,1),
IIF([Message Tracking].[Hour] = '8AM',0,1),
IIF([Message Tracking].[Hour] = '9AM',0,1),
IIF([Message Tracking].[Hour] = '10AM',0,1),
IIF([Message Tracking].[Hour] = '11AM',0,1),
IIF([Message Tracking].[Hour] = '12PM',0,1));
SELECT STATMENT
Code:
SELECT Format([Message Tracking].[Date & Time Left],"hh ampm") AS [Hour], Count(*) AS Calls, [Message Tracking].[Date & Time Left], [Message Tracking].[Date & Time Left]
FROM [Message Tracking]
GROUP BY Format([Message Tracking].[Date & Time Left],"hh ampm"), [Message Tracking].[Date & Time Left], [Message Tracking].Caller, [Message Tracking].[Customer Type]
HAVING ((([Message Tracking].[Date & Time Left]) Between [beginning_Date & Time Left] And [end_Date & Time Left]))
ORDER BY Format([Message Tracking].[Date & Time Left],"hh ampm") DESC;