Have a simple table with date, time, alarm.
Want to make query to count how many alarms in table every hour daily. If none then just show 0 for that hour. Time is formatted like 11:31:14.8
Any help.
Have a simple table with date, time, alarm.
Want to make query to count how many alarms in table every hour daily. If none then just show 0 for that hour. Time is formatted like 11:31:14.8
Any help.
Try:
SELECT DateEnter, Hour([TimeEnter]) AS Hours, Count(TimeEnter) AS CountOfTimeEnter
FROM Table1
GROUP BY DateEnter, Hour([TimeEnter]);
However, if there is no data for any hour, nothing will show for that hour.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.