Trying to count number of records by hour.

[racters]

Hello,



I'm trying to count the number of records for each hour of the day.

Ideally, I would like to bring in new data each day and be able to count the records. There is a field in the records that has date and time.

Is it possible to code the query to pull this data for today's date so that I don't have to change the date every day?

So far I think I need to add a total and use the criteria field to filter between the date and timestamps that I want to count.



The data in the field looks like this

TransmissionDate
8/19/25 16:00
8/19/25 16:00
8/19/25 15:13
8/19/25 15:13
8/19/25 15:13
8/19/25 15:13
8/19/25 15:13
8/19/25 15:13
8/19/25 15:13
8/19/25 15:13
8/19/25 15:05
8/19/25 15:05
8/19/25 14:20
8/19/25 14:20
8/19/25 14:20
8/19/25 14:20
8/19/25 14:20
8/19/25 14:20
8/19/25 14:20
8/19/25 13:40
8/19/25 12:40
8/19/25 12:39
8/19/25 12:39
8/19/25 12:39
8/19/25 12:39
8/19/25 12:39
8/19/25 12:39
8/19/25 12:39
8/19/25 12:39
8/19/25 12:39
8/19/25 12:39
8/19/25 12:39
8/19/25 12:39
8/19/25 12:12
8/19/25 12:06
8/19/25 11:40
8/19/25 11:40
8/19/25 11:40
8/19/25 11:40
8/19/25 11:38
8/19/25 0:21

I've added a total field and set it to count.

My query design criteria so far is

>=#8/19/2025# And <=#8/19/2025 1:00:00 AM#

Can I use some kind of variable to selects today's date and still have a range of hours?


I do apologize for the complete lack of knowledge on my end.

[ArviLaanemets]

Try

... WHERE Int(TransmissionDate) = Date

[Welshgasman]

Just group by date to get the number per day.
Group by date() and Hour() to get per hour

This should get you started

SELECT DateValue([F1]) AS Expr1, Count(Hour([F1])) AS Expr2, Hour([F1]) AS Expr3
FROM Times
GROUP BY DateValue([F1]), Hour([F1])
HAVING DateValue([F1]) = Date() ;

[jojowhite]

For Today's Count only:

SELECT Count(TransmissionDate) AS CountOfTransmissionDate
FROM YourTableHere 
HAVING (((DateValue([TransmissionDate]))=Date()));

For Each day:

SELECT DateValue([TransmissionDate]) AS [Date], Count(TransmissionDate) AS CountOfTransmissionDate
FROM YourTableHere 
GROUP BY DateValue([TransmissionDate]);