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*******@hotm ail.com> wrote in message
news:49******** *************** ***@posting.goo gle.com...

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....o r 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(interv al, date[,firstdayofweek[, firstweekofyear]])

cheers

paul g
"Jim Adams" <ji*******@hotm ail.com> wrote in message
news:49******** *************** ***@posting.goo gle.com...

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