# Access: Grouped Sums

• 2014-03-26, 05:36
accessnovice
Access: Grouped Sums
Hi,

First post but here it goes.

I have a data set as per the below which shows a unit (denoted by unidad) volumes and prices. This is broken down into hours however for one hour there can be more than one price and volume. I would like to be able to do the below

First is to find out the maximum total hourly volume offered for each unit, ideally for each month. So for example for CILCOR this would be 163 and 64 for GUA7 in February

21 11-Feb-13 ES V 79 23 O CILCOR THERMAL
21 11-Feb-13 ES V 79 40 C CILCOR THERMAL
22 11-Feb-13 ES V 84 36 O CILCOR THERMAL
22 11-Feb-13 ES V 79 23 C CILCOR THERMAL
23 11-Feb-13 ES V 83 36 O CILCOR THERMAL
23 11-Feb-13 ES V 79 29 C CILCOR THERMAL
24 11-Feb-13 MI V 79 28 O CILCOR THERMAL
24 11-Feb-13 MI V 79 39 C CILCOR THERMAL
1 12-Feb-13 MI V 82 37 O CILCOR THERMAL
21 11-Feb-13 ES V 14 24 O GUA7 THERMAL
21 11-Feb-13 ES V 10 22 C GUA7 THERMAL
22 11-Feb-13 ES V 12 34 O GUA7 THERMAL
22 11-Feb-13 ES V 9 27 C GUA7 THERMAL
23 11-Feb-13 ES V 23 22 O GUA7 THERMAL
23 11-Feb-13 ES V 41 28 C GUA7 THERMAL
24 11-Feb-13 MI V 8 25 O GUA7 THERMAL
24 11-Feb-13 MI V 22 36 C GUA7 THERMAL
1 12-Feb-13 MI V 24 39 O GUA7 THERMAL

Hope its clear and thanks in advance
• 2014-03-27, 02:47
Ensemble
Run a first query to Determine the totals:

SELECT Table1.Hora, Sum(Table1.Volume) AS SumOfVolume, Table1.Unidad
FROM Table1