Count how many records hourly?

[shootnow]

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.

[June7]

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.