Subject Query Help?
Author Lee
Hello all,

I need to be able to graph out time values in a cross tab type of format in
a report. The values are in a timestamp field with the time portion in 15
minute increments.

Ex.
1/2/2005 08:00:00
1/2/2005 08:15:00
1/2/2005 08:15:00
1/2/2005 08:30:00
1/2/2005 08:45:00
1/2/2005 08:45:00

I need to pull the records out Grouped on the minute portion for a
particular date so that the actual output would be:

Date COUNT
-----------------------------
1/2/2005 08:00:00 1
1/2/2005 08:15:00 2
1/2/2005 08:30:00 1
1/2/2005 08:45:00 2

Can somone offer assistance, possible an example?

Thank you,
---
Lee