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

People per hour Chart

P: 74
Hello Community.

I have a table consisting of a date / time field and a number field, the first being what time the people entered and the latter being the number of people to enter. I wish to display this data as a line graph with 15 minute intervals so every quarter of an hour it will display the count of all people through the door in that period to show busy times. I am using Access 2003. Do any of you people know if there is a solution to this problem.

Many Thanks
Mar 13 '12 #1
Share this Question
Share on Google+
5 Replies

P: 759
This is most to subscribe than to provide help because I have troubles to understand what you have and, also, what you wish to achieve.

In my opinion a door can be passed by only one person at a time.
In this case the second field (number) is no more needed because you can count the records in Date/Time field from 15 to 15 minutes.

But from your post the situation seems to be different:
You count, from time to time, how many people pass the door in the last time interval.
In that case why you not set the time intervals to a quart of hour ?

More, I don't understand if you have troubles to count peoples from 15 to 15 minutes or you have troubles to draw the graphic or both.

I am almost sure that a solution exist :) but you need to be more specific.
Mar 14 '12 #2

P: 74
sometimes more than one person enters with the registrant

Table data like this:

number time
3 01/01/12 10:30:05
1 01/01/12 10:32:25
4 01/01/12 10:34:02
2 01/01/12 10:37:35
1 01/01/12 10:44:15

An i need to plot a chart of people in verus time in 15 minute segments
Mar 14 '12 #3

Expert 100+
P: 634

This query will sum the Number column for 15 min period (period ending time)
Expand|Select|Wrap|Line Numbers
  1. SELECT Sum(tbllNumberCount.lngNumber) AS [Count], Format(Int([dtTime]*96+1)/96,"dd/mm/yy hh:nn:ss") AS [Time Period Ending]
  2. FROM tbllNumberCount
  3. GROUP BY Format(Int([dtTime]*96+1)/96,"dd/mm/yy hh:nn:ss");
For period begining query this
Expand|Select|Wrap|Line Numbers
  1. [dtTime]*96+1
shouold be changed to this
Expand|Select|Wrap|Line Numbers
  1. [dtTime]*96

Mar 14 '12 #4

P: 74
Many thanks, I will try it later and let you know!
Mar 14 '12 #5

P: 759
I hate SQL ! Totally. For all my life. Final word.
In attachment you will find a solution.

There are two databases: .accdb (for 2007) and .mdb (for 2003).
I have not tested in 2003.

And a link to a very useful article:

Good luck !
Attached Files
File Type: zip (175.1 KB, 166 views)
Mar 14 '12 #6

Post your reply

Sign in to post your reply or Sign up for a free account.