Subject | Query Help? |
---|---|
Author | Lee |
Post date | 2006-02-09T16:48:45Z |
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
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