Counts for every 30 minute intervals?

[showri]

I have a table which logs in student sigin and signout times. What i am trying to do is to get is count of students signed in for every 30 minute intervals.



Date 7:15-7:45 8:15-8:45 9:15-9:45
8/12/2010 1 0 3
8/14/2010 4 5 0
8/15/2010 3 2 1

Is there way i can do this?

thanks in advance..

 

[the_net_2.0]

have you looked at the timer() function to keep track of time?

 

[boblarson]

have you looked at the timer() function to keep track of time?

??????? That isn't even near what they are asking. How'd you come up with that one?

 

[vbaInet]

There's no way around this other than building the SQL string yourself and either using a DCount() function for every interval or a subquery. Then you can run the sql statement or apply it to a query.