• How would one go about grouping by dates, i.e. month, year?

    So a query from 12/30/2009 thru 1/2/2010 would have something similar to this.

    Meter Day Month Year Barrels

    ```````````````````````````````````````

    Meter1 12/30/09 Dec 2009 5

    Meter1 12/31/09 Dec 2009 10

    Meter1 DecTotal 2009 15

    Meter1 2009Total 15

    Meter2 1/1/10 Jan 2010 8

    Meter2 1/2/10 Jan 2010 12

    Meter2 JanTotal 2010 20

    Meter2 2010Total 20