Report by hour / day

[Jim Adams]

My Access app stamps the date and time for each database entry.

I'd like to generate a report of:

- the number of entries per hour of day (0 - 23), and also
- the number of entries per day of month (1 - 31)

Any insights are greatly appreciated.

Thanks,

Jim

[Larry Linson]

Take a look at using Totals Queries. You get from regular SELECT to totals
queries in the Query Builder on the menu by View | Totals. You'd create a
calculated field to extract the day or the hour, and then select Group By on
that Field.

Larry Linson
Microsoft Access MVP

"Jim Adams" <ji*******@hotmail.com> wrote in message
news:49**************************@posting.google.c om...

My Access app stamps the date and time for each database entry.

I'd like to generate a report of:

- the number of entries per hour of day (0 - 23), and also
- the number of entries per day of month (1 - 31)

Any insights are greatly appreciated.

Thanks,

Jim

[Salad]

Jim Adams wrote:

My Access app stamps the date and time for each database entry.

I'd like to generate a report of:

- the number of entries per hour of day (0 - 23), and also
- the number of entries per day of month (1 - 31)

Any insights are greatly appreciated.

Thanks,

Since your apps have a date time stamp, when you create a Totals query
to roll them up, you may want to convert the date field using DateSerial
and TimeSerial....or use the Format. Using DateSerial will be better
since it will sort better. Simply make that an extra column in the
query.

For example, let's say you have a datetime of 12/19/03 17:00:55 stored
to variable x and today is the 19th of Dec.

If you entered Debug.Print x >= Date And x <= Date it would return
False. Why? Because Date is 12/19/03 00:00:00.

[Kinetic - Paul G]

use the "datepart" function to create a calculated field for the hour / and
/ or day and use this field as a group level in your report

Syntax

DatePart(interval, date[,firstdayofweek[, firstweekofyear]])

cheers

paul g
"Jim Adams" <ji*******@hotmail.com> wrote in message
news:49**************************@posting.google.c om...

My Access app stamps the date and time for each database entry.

I'd like to generate a report of:

- the number of entries per hour of day (0 - 23), and also
- the number of entries per day of month (1 - 31)

Any insights are greatly appreciated.

Thanks,

Jim