I want to get the count of id for a date and hour

06/09/2004 09:19:00


for the date = 06/09/2004
i want the count of ID for the hour = 09


for access 2000

SELECT COUNT users.id WHERE users.dates = #06/09/2004# AND hour(users.dates) = #9#

(i dont want to have to write the 0 of 09)

it doesn't work

with variable of course

SELECT COUNT users.id WHERE users.dates = #[@date]# AND hour(users.dates) = #[@hour]#



thank you