title: Access query to partition data and sum each partition?
body: <p>I have a query with the fields    <code>date</code> <code>hour</code> and <code>value</code>.<br>
  It looks something like this</p>
  
  <pre><code>    date       hour   value 
      xx/xx/xx     15     100
      xx/xx/xx     30     122
      xx/xx/xx     45      50
      ...         100     100
      ...         115      23
      ...         ...     ...
      ...         ...     ...
      ...        2400     400
      ...          15      23
  </code></pre>
  
  <p>Basically, <code>date</code> is the date, <code>hour</code> is the hour, and <code>value</code> is the value for that particular 15 minute interval.  What I have been trying to figure out is a way to take each hour (so 15, 30, 45, and 100) or (1015, 1030, 1045, 1100) [As you can see hours are military-esque 1:00pm is 1300 and midnight 2400], and sum their values together.  So i am looking to return something like this:</p>
  
  <pre><code>    xx/xx/xx    100     372
      xx/xx/xx    200     23 + (130 data) + (145 data) + (200 data)
  </code></pre>
  
  <p>And so on...
  The table has on average around 100 days and they all start from 15 to 2400 incrementing by 15 with varying numbers for the value column.</p>
  
  <p>I have thought about using a partition, group by, etc. with no real ideas how to tackle it. Essentially I have to take 4 rows (an hour), sum their values, spit out the date, hour, and summed value then repeat for every day.  I am not asking for code, just some help with what i should be using since this seems like a simple problem minus the key to solving it.</p>
  
  <p>Any help is greatly appreciated, Thank you!</p>