435,561 Members | 3,083 Online
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
5 Replies

 100+ 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 etc.... An i need to plot a chart of people in verus time in 15 minute segments Mar 14 '12 #3

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

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

100+
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:
http://www.vb123.com.au/toolbox/09_a...07charting.htm

Good luck !
Attached Files
 15minutes.zip (175.1 KB, 166 views)
Mar 14 '12 #6