-
date + hour
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|