People per hour Chart

[jimleon]

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

[Mihail]

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.

[jimleon]

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

[MikeTheBike]

Hi

This query will sum the Number column for 15 min period (period ending time)

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

[dtTime]*96+1

shouold be changed to this

[dtTime]*96

HTH

MTB

[jimleon]

Many thanks, I will try it later and let you know!

[Mihail]

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 !