By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,510 Members | 1,445 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,510 IT Pros & Developers. It's quick & easy.

Report by hour / day

P: n/a
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
Nov 12 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
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

Nov 12 '05 #2

P: n/a
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.
Nov 12 '05 #3

P: n/a
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

Nov 12 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.